[Tutor] web application and database caching technique

Alan Gauld alan.gauld at freenet.co.uk
Thu Aug 17 22:58:24 CEST 2006


>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.


More information about the Tutor mailing list