Speeding up UpdateRecord

[Jay Madren]

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?)

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.


On Sat, Jan 11, 2014 at 9:43 AM, Beatrix Willius <bwillius at gmx.de> wrote:

> Database: version 5.5, Xojo 2013r4, 10.9
>
> Class way:
>
> dim theCleaner as CleanerInterface
> theCleaner = new CleaningMaster ‘some text options were selected here
> theCleaner.setString theCursor.Field("MessageBody").GetString
> theCursor.Field("MessageBody").SetString theCleaner.execute
> theCursor.UpdateRecord
>
> Multiuser: no
>
> Size of records: couple of kb, can vary. This is the text version of an
> email message that is handled here.
>
> 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20140111/f4335fea/attachment.html>