Hi All

I have a table with 500 rows of static data. Each row has a date colum.

My queries will be to get matching rows between 2 dates.

I wrote a program which uses query cache, loaded whole table using select * from table, then I thought subsequent queries which put date constraint like "select * from table where date > 12/1/2009" will get data from cache as it is already loaded.

When I print time to run the subsequent queries with date , I get random numbers sometime high some times low..

Is there a good strategy to deal with these cases.
Please let me know.

Thanks
Macy