Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Databases Stored In memory

by lhoward (Vicar)
on May 06, 2002 at 01:15 UTC ( #164200=note: print w/ replies, xml ) Need Help??


in reply to Databases Stored In memory

Items that you store in memory with mod_perl are only available to the same apache process, so that may not help you much. You could try using IPC::Shareable or IPC::ShareLite to make your datastructure available across processes. This can buy you a lot of performance, but has a lot of risks (i.e. if you reboot your system the data in shared memory is gone, unless you have a facility to write it to disk). Your best bet is probably to use a real database (Postgres, mysql, etc...) and if it isn't fast enough for you then consider some sort of in-memory caching. mod_perl can buy you a lot with traditional databases performance wise (presistant cached database handles, etc..)


Comment on Re: Databases Stored In memory

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (9)
As of 2015-07-03 17:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (54 votes), past polls