Caching some tables (SQL CE)

Nov 13, 2013 at 11:54 AM
My database has some simple tables with two or three fields like (id : int; name : string) and about 10,000 records, so SELECT works to slow. Is there any way to cache these tables (my device has plenty RAM) to speed up reading data from these tables?