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

[Alexey Pechnikov]

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 request"
can produce about 1 kB data by transaction and so 200kB data per 
second (20 tps as above). By 86400 second per day and 365 day per 
year your site produce ~6 TB database!
This is not a small project :-)

May be you speak about user sessions? User session can continue
a lot of times but total requests count can be small.

I'm using SQLite for few GB databases but with ~1000 concurrent
sessions. See some my tests and results here
http://geomapx.blogspot.com/2009/09/sqlite-3617-mobigroup2.html
Article is russian but you can read sql listings. And I did add a few
english comments.

I can add that time of the creating new SQLite db connection is about 
0.5 ms and so you can open database 2000 times per second on 
single-core processor. So the total amount of readers can be huge.

P.S. GeoIP by SQLite
http://geomapx.blogspot.com/2009/10/geoip-sqlite.html
Try to download the dataset and test it on your site.

Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Pavel Ivanov]

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 value if not over it already. Because unless
you turn off synchronization with disk SQLite can do not so much
writing transactions per second (actual numbers depend on hardware and
file system settings). So assuming that besides your application
there's others working on the same server you will feel a lot of
contention for the disk I/O.

Pavel

On Thu, Oct 29, 2009 at 9:27 AM, Sebastian Bermudez
 wrote:
> 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 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

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

[O'Neill, Owen]

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