Database connection design?
by Stefan Lundmark · in General Discussion · 03/31/2006 (7:19 am) · 2 replies
I couldn't find anything directly relative to this topic, so I figured I'd ask as I'm curious.
How do you usually handle database connections from one server to another?
Say Apache to MySQL.
I was under the impression that Apache spawned one connection to the database for each client connected, and kept those open until the client disconnected - etc. But it doesn't seem logical.
Why not keep one connection to the database and just queue from all clients?
How do you usually handle database connections from one server to another?
Say Apache to MySQL.
I was under the impression that Apache spawned one connection to the database for each client connected, and kept those open until the client disconnected - etc. But it doesn't seem logical.
Why not keep one connection to the database and just queue from all clients?
About the author
#2
I do still wonder what the positives/negatives are with the two implementations, but that page does answer what options apache has.
Thanks Benjamin!
04/04/2006 (3:16 pm)
Good information.I do still wonder what the positives/negatives are with the two implementations, but that page does answer what options apache has.
Thanks Benjamin!
Torque Owner Benjamin Bradley