Page 1 of 1
mysql connection opening time
Posted: Fri Jan 14, 2011 9:36 pm
by PaxBritannia
Since the website I'm working on has several databases on several servers, I need to connect to them. All. Individually.
Is there significant overhead in opening and closing around 10 connectons per page? How about 60 connections per page?
pax.
Re: mysql connection opening time
Posted: Fri Jan 14, 2011 10:16 pm
by Chris
Might make a few milliseconds difference but not much as long as the servers aren't too remote or slow.
Re: mysql connection opening time
Posted: Fri Jan 14, 2011 10:44 pm
by PaxBritannia
Thats good to know. Else my data architecture would have been doomed.
Pax.
-----UPDATE-----
Yay me!
Session database successfully sharded!
Avg. connections per authentication: 1!
Avg. connections per login: 3!
Avg. connections per signup: 7!
Now to shard everything else!
The connections are going to be around 1 per item in the 'galleryview' of the site. If you view 60 items at a time, thats at least 65 connections a page!
pax.