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
