1
I currently use Mysql on my server with a limit of 50 simultaneous connections.. thought to use SQL Server which in turn has no simultaneous connection limit but is very expensive!!..
So I thought about using Sqllite, but I would like to know if there is any simultaneous connection or storage limit?
The decisions can not be like this, you need to see your problem, because theoretically Mysql has no limit, can have a configuration, but just change. On the other hand has a practical limitation, which I doubt is as low on any machine.
– Maniero
But then Maniero , in case I use shared server and the host has these limitations. of at least 25 simultaneous connections. , for example: my limit is 50 simultaneous connections and I have a script that first makes 1 select (after 10.20 seconds) makes 1 Insert, 2 select, 2 update , thus opening 5 connections, even being fast (in a matter of thousandths).. having a base of 200 users, with around 100 of them logged in at the same time causing error, as if 11 users are online at the same instant of running the script 11*5 = 55 connections . . and the already error server
– Di Max Developer
Very simple, change hosting, much less traumatic than changing databases, and much more sensible for all possible points of view.
– Maniero
What do you mean by "connection"? Normally you have no "connection" to Sqlite, after all, natively it is not a server.
– Bacco
And if it’s the same script that does all this, why does it require 5 simultaneous connections? It doesn’t just one and run all operations by the same connection?
– Woss
is @Maniero followed his advice and colleague Anderson and I changed hosting and I reread the connection script, now this 100% vlw guys!
– Di Max Developer