I had tried to use SQL statement to retrieve data record from SQL server, but when the database grow, the query speed getting slower. I just want to get most recent 5 records, any way to make it fast? Below is the SQL
SELECT Top (5) EventNumber, IP, DateTime, DateTimeStamp, EsdMaxLog, EsdMaxLin, EsdMaxAbs, EsdCntAll, EsdCntLast, SvMax, SvCurrent, EsdLimLog, EsdLimLin,
EsdLimAbs, Distance, SvRange, CdmFilter
FROM EM_AWARE
WHERE (DateTimeStamp > @Param1) AND (DateTimeStamp < @Param2)
ORDER BY DateTimeStamp DESC