Subject: Re: [sqlite] SQlite performance on multi process env Hello, Zhrahman,
Regarding: "... kindly suggest how to properly have the database shared in memory among n number of processes. So they can execute select operatins(read only no update on teh database) effeciently." If the large number of processes are unavoidable, you might want to consider: 1) Writing a server layer that would be the only process to open the DB file and service the requests for the other processes. 2) Modifying such a layer already written by others. 3) Using a database designed for lots of simultaneous clients, such as Postgres or MySql. (I believe the succinct advice has been something like, "Think of sqlite as a replacement for fwrite, not as a replacement for Oracle.") _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users