-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 03/11/11 11:32, Paxdo Presse wrote:
> Roger, I meant: I feel that WAL is rarely used with its new
> capabilities.

Outside almost 100 million Android devices?

> SQLite + WAL may, perhaps, now compete with Mysql / postgres to handle
> web apps with thousands of users. But what is its limit?

Limit of what?  The number of concurrent requests you can serve will be
limited by hardware, operating system, and all the other code that runs in
order to service a request.  SQLite could be anywhere from 95% of the code
run to service a request to 2%.

You can of course find out exactly what happens in your exact setup by
implementing a representative benchmark.  There are plenty of testing
tools (eg ab).

> In this context, there is currently not a lot of feedback, I feel. 
> There are not enough people know about these new opportunities.

I'm still very confused what exactly it is you want.  Do you want some
reassurance that SQLite will never give wrong answers?

  http://www.sqlite.org/testing.html

Do you want reassurance it can handle any load thrown at it?  The code is
performant, but what can be handled will depend a lot more on the
non-SQLite code.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAk6y7UgACgkQmOOfHg372QTi7wCfdlTRXDdTUwfNZ9ndJfxKXGRg
CMIAnj7X1GZXvLHMnyY6CO7K/jqkhjqp
=kTgr
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to