Re: [GENERAL] How to implement table caching

2005-08-17 Thread Jim C. Nasby
There is also http://people.freebsd.org/~seanc/pgmemcache/ On Mon, Aug 15, 2005 at 04:54:31PM -0500, Thomas F. O'Connell wrote: > Andrus, > > You might consider something like materialized views: > > http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html > > Whether table cachin

Re: [GENERAL] How to implement table caching

2005-08-15 Thread Thomas F. O'Connell
Andrus, You might consider something like materialized views: http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html Whether table caching is a good idea depends completely on the demands of your application. -- Thomas F. O'Connell Co-Founder, Information Architect Sitening,

[GENERAL] How to implement table caching

2005-08-14 Thread Andrus Moor
To increase performance, I'm thinking about storing copies of less frequently changed tables in a client computer. At startup client application compares last change times and downloads newer tables from server. CREATE TABLE lastchange ( tablename CHAR(8) PRIMARY KEY, lastchange timestamp with