how to get top 1 date really fast from a large table
Posted on 2010-09-08
I have got a table range from 10k to 200k rows...
When I query for the latest date ...
"Select TOP 1 [DateTime] From [M] " & _
"ORDER BY [DateTime] DESC"
It tooks a lot of time ... is there a way i can make a process faster?
any idea at all will be great.
Well i am doing it in sqlite so but any idea would be great....