Slow write to sqlite on usb sticks

[Peter Haworth]

Glad it worked for you Terry.  Sometimes the performance hits on this stuff
aren't obvious until you have to deal with slow i/o speeds.


Pete
lcSQL Software <http://www.lcsql.com>



On Thu, Apr 26, 2012 at 7:29 PM, Terry Judd <tsj at unimelb.edu.au> wrote:

>
> On 27/04/2012, at 3:37 AM, Peter Haworth wrote:
>
>  Hi Terry,
>>
>> You can still do individual INSERTS, just need a few lines of extra code
>> at
>> the start and end of your code.  Here's an amended version of your code
>> with the BEGIN/ROLLBACK/COMMIT in place.
>>
>
> Peter - using the BEGIN/COMMIT form seems to have sped up things
> considerably. Applying individual inserts the 'old' way created a temporary
> journal file for each insert - actually two, as attachments were handled
> separately to the message content. Now just two journal files are created
> and the total write time has been reduced from over a minute (on some very
> slow USB sticks) to just a few seconds. I can certainly live with that.
>
> Thanks again,
>
> Terry...
>
> Dr Terry Judd
> Senior Lecturer in Medical Education
> Medical Education Unit
> Faculty of Medicine, Dentistry & Health Sciences
> The University of Melbourne
>
>
>
>
> ______________________________**_________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/**mailman/listinfo/use-livecode<http://lists.runrev.com/mailman/listinfo/use-livecode>
>