Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Re: Re: Sharing database handle

by graff (Chancellor)
on Apr 20, 2002 at 01:02 UTC ( #160715=note: print w/replies, xml ) Need Help??

in reply to Re: Sharing database handle
in thread Sharing database handle

This is a nifty thought, but I'd worry that it would make the parent/server a bit monstrous and hard to get right. I guess if each child request is read, executed and answered back to the child in one block, it's certainly manageable.

There still is the empirical question: is it better to serialize all activity through a single, very active connection, as opposed to having a bunch of connections (leaving it to the DBMS to coordinate the actions, which is, in part, what it was written to do)? I don't really know that yet (sorry).

Replies are listed 'Best First'.
Re: Re: Re: Sharing database handle
by Zapawork (Beadle) on Apr 21, 2002 at 18:05 UTC
    Sorry about the late response,
    Proof to the pudding, so to speak, for this type of practive goes back to the ODBC models that all of your modern day websties use.
    Having one central connection allows you to control access while guaranting preformance. If you need data in a large scale form, you usually implement application servers to cache and give performance enhancements.
    Hope this helps
    Dave -- Saving the world one node at a time

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://160715]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (9)
As of 2018-06-20 14:03 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (116 votes). Check out past polls.