Beefy Boxes and Bandwidth Generously Provided by pair Networks Joe
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Best way to do caching of Class::DBI objects from a MySQL database

by zebedee (Pilgrim)
on May 01, 2005 at 16:13 UTC ( [id://453075]=note: print w/replies, xml ) Need Help??

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.


in reply to Best way to do caching of Class::DBI objects from a MySQL database

MySQL replication has worked well for me. i.e. use the replicated version of the database rather than the overloaded primary version.
MySQL 4.x offers query caching and that has worked *really* well for me on a site with few updates and lots of reads.
Update:Gah! Just noticed your paragraph about not changing MySQL version - which renders my comment above pointless.
  • Comment on Re: Best way to do caching of Class::DBI objects from a MySQL database

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://453075]
help
Sections?
Information?
Find Nodes?
Leftovers?
    Notices?
    hippoepoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.