Slow write to sqlite on usb sticks
Richard Gaskin
ambassador at fourthworld.com
Thu Apr 26 10:39:42 EDT 2012
Terry Judd wrote:
> I have a feeling that not all USB memory sticks are equal either.
Indeed, not by a long shot.
Given that db writes require a lot of jumping around in the internal
b-tree, there's only so much that can be done to speed them up. But for
sustain read/write operations, I've found significant variance among
thumb drives.
Last year I picked up this XPorter Rage because the reviews raved about
its unusual quad-channel USB interface - over a single port it opens up
four logical transfer channels that make fuller use of the connection to
provide a big speed boost for the sort of "sneakernet" transfers and
quick backups I do:
Patriot Xporter XT Rage 16 GB USB 2.0
<http://tinyurl.com/82dtpeb>
When copying lots of small files the performance isn't as noticeable due
to the general overhead of USB and the nature of flash drives, but for
sustained read/writes it's able to use the one-time hit in setting up
the connection quite efficiently for overall great performance, far
beyond any other flash drive I've used.
--
Richard Gaskin
Fourth World
LiveCode training and consulting: http://www.fourthworld.com
Webzine for LiveCode developers: http://www.LiveCodeJournal.com
LiveCode Journal blog: http://LiveCodejournal.com/blog.irv
More information about the use-livecode
mailing list