>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. _______________________________________________ Tutor maillist - [email protected] http://mail.python.org/mailman/listinfo/tutor
