[Tutor] web application and database caching technique

[anil maran]

Postgresql 8
and python 2.4
let me find out how to do the caching on db, thanks if
you have other pointers on how to cache db in python
pls let me know

--- Alan Gauld <alan.gauld at freenet.co.uk> wrote:

> >i m trying to build a webapplication, i need to
> cache db records 
> > as it has become very slow the sql queries and
> retrival
> > can you guys helpe me out in designing cache
> structures/ hash 
> > tables for these cases 
> 
> Which database? Most relational databases have
> caching as a 
> feature that you can configure. It may be that you
> can simply 
> increase the size of the database cache on the
> server?
> 
> A lot easier and usually a lot more efficient and
> reliable too.
> 
> Fixing database scaleability issues is rarely best
> done 
> outside of the database! (Small volume query
> improvements 
> are another matter entirely!)
> 
> Alan G.
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com