Hi Sebastian, The reading should be ok, but you'll have to be *really* careful how you handle that many concurrent writers.
See the recent thread titled "shared cache mode and 'LOCKED'" which has a discussion of topics with the same problem. Cheers. Owen -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Sebastian Bermudez Sent: Thursday, October 29, 2009 1:28 PM To: sqlite-users@sqlite.org Subject: [sqlite] has used anyone sqlite for production web sites ?? i have an very small web site ( 60/80 Concurrent users )... running with mysql...... but i need transactions.... ( and my web hosting does not support innodb ).... but have support for SQLITE 2.x & 3.x)....... The web site has built with PHP using PDO...... the max..db-load for a request....is.... around 8 SELECT querys on single tables by Primary key....(Integer field)... Has anyone used SQLITE in a comparable environment ??? can i replace the DB ??? there are max..of 10 concurrent writers ( on single tables too)...( 4/7 Insert or Update per request....) in this point i need transactions ! In sqlite transactions blocking readers ??? There are case studies for web sites using sqlite ?? Yahoo! Cocina Encontra las mejores recetas con Yahoo! Cocina. http://ar.mujer.yahoo.com/cocina/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
