[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