Slow write to sqlite on usb sticks

[Richard Gaskin]

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