Re: [sqlite] has used anyone sqlite for production web sites ??

Hello! Add SQLite database to your current site and write to it too. You will see how this work on you environment. About your site load. 60/80 Concurrent users with common query time about 50 ms produce 1200/1600 requests per second. "10 concurrent writers" with "4/7 Insert or Update per reque

Re: [sqlite] has used anyone sqlite for production web sites ??

Your writing transactions most probably will not block readers, but each writer will block others. So whether SQLite is applicable for you depends on how much load your server will have. If it's 60/80 per second (I wouldn't call such site small :) ) then you can try it but it's already a boundary v

Re: [sqlite] has used anyone sqlite for production web sites ??

riginal 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

[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 requestis.