On 31 Dec 2010, at 3:41am, Eric Smith wrote: > But, if you insist on using SQLite in WAL mode, I'd just use an on-disk > database with PRAGMA synchronous=off. That way the OS will keep a lot > (hopefully most) of your database in RAM anyway. You shouldn't care > about corruption on power loss or app crashes because you wanted to use > the database in-memory anyway.
This seems to be preferred solution #1. One other is to devise your own client/server protocol, optimised for your own expected data flow. Then all your clients can run as separate processes anyway, removing all the problems that using threads introduces. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
