"Cache" mysql table locally to sqlite ?? (good or bad idea?)

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.

several times per second? ... cache it..