Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re: Re: OO Perl & RDBMS Strategy Question

by Stegalex (Chaplain)
on Aug 30, 2002 at 13:25 UTC ( #194102=note: print w/replies, xml ) Need Help??

in reply to Re: OO Perl & RDBMS Strategy Question
in thread OO Perl & RDBMS Strategy Question

I hope I am not taking the following quote out of context:

When an object is created, it issues a select for the whole table (or possible several smaller chunks and accumulates) so that it has its data available for immediate read access

Selecting an entire table into memory becomes a real problem when you're dealing with large tables. Also, selecting the table into memory does not lock it. One important thing to remember about some databases (Oracle for one) is that the DB makes every effort to keep frequently accessed blocks of data in memory so that you don't have to do a physical read/write when doing selects, inserts, updates, deletes. This explains (in part) why Oracle soaks up so much memory and CPU.

I like chicken.
  • Comment on Re: Re: OO Perl & RDBMS Strategy Question

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://194102]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (7)
As of 2022-11-29 22:13 GMT
Find Nodes?
    Voting Booth?