PDA

View Full Version : "Cache" mysql table locally to sqlite ?? (good or bad idea?)



georgep
15th July 2009, 23:37
Hey all,

On one of my applications i have a "big" table (several tens of thousands rows) that I download from a mysql server. Is it a good idea to copy this table and import it to a sqlite memory database on the local host ? (in order to save SQL querys going through the internet) Is there a better way? The application can query the table several times per second.


Thanks.

nish
16th July 2009, 03:25
several times per second? ... cache it..