>
>An Index caching overload effect ?
>
>try, and post this time:
>
>use bhav_data
>SET EXACT ON
>=lOOKUP(symbol, m.THISVALUE,symbol)
>SELECT date,open,high,low,close,tottrdqty,sma9,sma12,sma26 FROM bhav_data;
>where symbol = m.THISVALUE INTO CURSOR tempDETAIL nofilter
>
Minimum time taken is 9 secs
but if i run the second time with the same value in thisvalue it runs under .5 secs
like
First run with thisvalue = 'ABCD' -- 10 secs
second run with thisvalue = 'dfsd' -- 10 secs
third run with thisvalue = 'ABCD' -- .5 secs
that is wilhout cloing the table