On Mon, Aug 18, 2008 at 04:38:03PM -0400, Darren Landrum wrote: > 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.
On a modern OS unless you lock the memory that can (and does) happen even if things are loaded into memory since the OS will often push those pages out to swap/paging (more so under high buffered IO). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users