On 26 May 2012, at 6:25pm, Udi Karni <uka...@gmail.com> wrote: > In any event - breaking the SQL up in 2 is still at least twice as better.
I do see huge SQL commands on this list sometimes: great big commands of hundreds of characters which could be done simpler and faster if split into two small SQL commands. > Where SQlite seems to run superfast all the time - is :memory: tables - if > you have the RAM. Maybe that's the real direction with large DBs. A giant > RAMDisk ? Solid State Drives. Those things of Flash memory you can use instead of a rotating hard disk drive. They're getting very cheap. A lot of the time taken for hard disk access is spent waiting for the disk to rotate to the right place so the read/write heads can get at the sector you want. SSDs never have to wait. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
