Re: [Tutor] web application and database caching technique

2006-08-18 Thread 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 <[EMAIL PROTECTED]> wrote: > >i m trying to build a webapplication, i need to > cache db records > > as it has become very slow t

Re: [Tutor] web application and database caching technique

2006-08-17 Thread Danny Yoo
On Thu, 17 Aug 2006, Alan Gauld 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 I second Alan's suggestion: talk to you

Re: [Tutor] web application and database caching technique

2006-08-17 Thread Alan Gauld
>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

[Tutor] web application and database caching technique

2006-08-17 Thread anil maran
i m trying to build a webapplication, i need to cache db records as it has become very slow the sql queries and retrivalcan you guys helpe me out in designing cache structures/ hash tables for these cases 1. Scenario One:    * Huge number of reads    * Few writes    * One row accessed from db pe