Marian Aldenhoevel wrote: > Hi, > > >> Are you able to benchmark it using an actual PC's local hard drive? >> Just for comparison. To be fair, you'd have to use the same build of >> sqlite, or at one that was built the same way. >> > > That would be quite an effort. > > For a quick data-point I copied the database file to my > development-machine running Ubuntu Server 7.x. > > The statement runs 11s on that system. That still feels somewhat > excessive for a simple "update 'em all", but I have no data to fairly > compare it with. >
FWIW, I ran your simple example on a Windows XP machine through the Ruby driver and got 8 seconds for the update. John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
