Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

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]
[Corion]: choroba: I think it's great that your kids (have to) perform in public - that makes you appreciate any kind of show much better IMO

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (4)
As of 2017-12-12 09:09 GMT
Find Nodes?
    Voting Booth?
    What programming language do you hate the most?

    Results (327 votes). Check out past polls.