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