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. Ciao, MM _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users