Speeding up UpdateRecord

[Beatrix Willius]

Okay :-)

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.
    

On 11.01.2014, at 15:27, Jay Madren <jay at jaymadren.com> wrote:

> We need more information. Which database? What do you mean "class way"? Is this multi-user? How big are the records, on average? How are the records to be updated selected?

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20140111/9e0c68dd/attachment.html>