Darren Landrum wrote: > D. Richard Hipp wrote: > >> Why do you want to load the database into memory? Why not just open >> it and use it off of disk? >> > > Software synthesis applications, particularly disk-streaming samplers, > are very high-performance programs, so I'd like to keep disk I/O as > clear as possible. Every touch of a GUI widget will result in a query > run on the database, so it's best that that be in memory, I think. >
Just a side comment, you may want to check your assumptions with some testing. GUI operations tend to be rather expensive and can outweigh a disk access by an order of magnitude. John Elrick Fenestra Technologies _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users