>
>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