>>>
>>>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
>
>this confirm the caching effect.
>
>try
>
>SELECT date,open,high,low,close,tottrdqty,sma9,sma12,sma26 FROM bhav_data;
>where symbol = m.THISVALUE AND symbol = symbol INTO CURSOR tempDETAIL nofilter
>
No the result is the same. the above doesnt make any difference.
Can u hilight what u mean by cashing effect ? what is going on ?