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.
mysql connection opening time
Re: mysql connection opening time
Might make a few milliseconds difference but not much as long as the servers aren't too remote or slow.
Fighting for peace is declaring war on war. If you want peace be peaceful.
-
PaxBritannia
- Posts: 680
- Joined: Sun Apr 18, 2010 1:54 pm
Re: mysql connection opening time
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.
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.