Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
Hi Suhas
What are you really trying to do? There is no value in creating multiple aopen arrays as each removes the previous one.
I can't believe the time spent building the .IDX is saving anything versus having the indexes. The set relation is not a factor. The SQL inside the scan ignores that and the SET ORDER TO 1 too.
>Select dist symbol from bhav_data into cursor dist1 nofilter && runs fast
>
>Select bhav_data
>index on symbol to symbol.idx
>set order to 1
>select Dist1
>set relation to symbol into bhav_data
>scan
> select open from bhav_data where symbol = dist1.symbol into array aopen order by date
>endscan
>
>*The above runs verry verry fast any tim first time or second time
>
>* tried variations
>* without setting the order and relation,
>* tried using already built IDX Or CDX instead fresh build
>* all the other methods runs very slow the first time and the n fast second time without restarting the system or VFP (maybe uses cached copy)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only