<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Isn't it faster to use a numeric index of the field rather than the name of the field as well as avoiding the casting of the field type?<div><br></div><div><div>Instead of:</div><div>theCursor.Field("MessageBody").SetString theCleaner.execute</div><div><br></div><div>shouldn't it be </div><div>theCursor.varcharfield(1).value theCleaner.execute</div><div><br></div><div>Assuming the field is VarChar and in the first position of the cursor. Not sure this would make a significant difference, but I think it is faster, no?</div><div><br></div><div>Steve</div><div><br></div><div><br></div><div><span style="font-family: Helvetica; font-size: 12px;">--</span></div><div><div apple-content-edited="true"><span class="Apple-style-span" style="border-collapse: separate; font-family: 'New York'; border-spacing: 0px;"><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: normal normal normal 12px/normal Helvetica; ">Steve Albin, Montclair, NJ</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span class="Apple-style-span" style="font-family: Helvetica; font-size: 12px; "><a href="http://www.steve-albin.com">http://www.steve-albin.com</a></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font class="Apple-style-span" face="Helvetica"><a href="http://www.jazzdiscography.com">http://www.jazzdiscography.com</a></font></div></span>
</div>
<br><div><div>On Jan 11, 2014, at 10:53 AM, Jay Madren <<a href="mailto:jay@jaymadren.com">jay@jaymadren.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr"><div class="gmail_extra"><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Well, updating a large text field across thousands of records is never going to be instantaneous. How slow is too slow? (how long is it taking per 100 or per 1000 records?)</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">What are you updating the message text with? Is it constant, or variable depending on the message itself? If the changes can be formulated in SQL only, then it could be faster. But I assume you're not using a vserver, so the speed increase may be marginal.</div>
<div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Jan 11, 2014 at 9:43 AM, Beatrix Willius <span dir="ltr"><<a href="mailto:bwillius@gmx.de" target="_blank">bwillius@gmx.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204, 204); border-left-style: solid; padding-left: 1ex; position: static; z-index: auto;"><div>Database: version 5.5, Xojo 2013r4, 10.9</div><div><br></div><div>Class way: </div><div><br></div><div><div>dim theCleaner as CleanerInterface</div>
<div>theCleaner = new CleaningMaster ‘some text options were selected here</div><div>theCleaner.setString theCursor.Field("MessageBody").GetString</div><div>theCursor.Field("MessageBody").SetString theCleaner.execute</div>
<div>theCursor.UpdateRecord</div><div><br></div><div>Multiuser: no</div><div><br></div><div>Size of records: couple of kb, can vary. This is the text version of an email message that is handled here.</div><div><br></div><div>
Selection of records to be updated: all. For my test I took a couple of thousand mails from the old Realbasic mailing list, lots of newsletters and some spam.</div></div></blockquote></div><br><br></div></div>
_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>http://lists.macserve.net/mailman/listinfo/valentina<br></blockquote></div><br></div></div></body></html>