View Full Version : Calls to database
What is the max # of calls or connections to the database?
Tyler
08-26-2008, 12:04 AM
You should not use any persistent connections. As for normal connections, they only last a fraction of a second normally so you really don't need to worry about it. Make sure you close your database connection when you are done.
I have 20 separate queries on one of my phpbb page, when that page loads, all queries run at same time. what do u mean by fraction of a section
UnlimitedMB
08-26-2008, 02:48 AM
The maximum is 10 connections.
There is no limit to the number of queries per connection.
When your page loads the 20 queries are not "run at the same time", they are run in sequence one after the other, using only 1 connection.
The maximum is 10 connections.
There is no limit to the number of queries per connection.
When your page loads the 20 queries are not "run at the same time", they are run in sequence one after the other, using only 1 connection.
Is that at Ulmb.com or are you generally speaking of connections to database.
thanks
Tyler
08-27-2008, 02:55 AM
The 10 connections could be different other places, but it is a standard practice to have it at what we have it. The other part is everywhere.
UnlimitedMB
08-27-2008, 02:55 AM
You quoted two responses, to which are you referring?
The 10 connections is a limit we set, the rest is how mysql always works.
You quoted two responses, to which are you referring?
so, is it one query per connection. then 10 connections means 10 queries can be loaded stimulious at the same time.
There is no limit to the number of queries per connection.
is that same for most of shared servers. I have ******** has my host.
thanks :)
Tyler
08-28-2008, 03:12 AM
Are you serious?
Please read the response above. Your question has been answered.
You shouldn't be asking us for support for another company.
vBulletin® v3.8.4, Copyright ©2000-2012, Jelsoft Enterprises Ltd.