hi,
Ok, sorry If I offend You.

What I basically want do is

Table structure

create table bhav_data.dbf free ;
(symbol c(20),series c(20),open Y,high Y,low Y,close Y,;
last Y,prevclose Y,tottrdqty I,tottrdval Y,;
sma9 Y,sma12 Y,sma26 Y,;
timestamp c(12),date d,delqty I,delpercent N(6,2))

select bhav_data
INDEX ON DTOS(DATE)+SYMBOL TAG PK
index on symbol+dtos(date) tag pk1 && Not present in the link below
INDEX ON SYMBOL TAG SYU Unique
index on date tag dau Unique
index on date tag da
INDEX ON SYMBOL TAG SY

No of records 800000
Size 121686 kb - DBF , 21457KB - cdx

link
http://rapidshare.com/files/49732096/bhav_data.part01.rar
http://rapidshare.com/files/49732097/bhav_data.part02.rar
http://rapidshare.com/files/49732098/bhav_data.part03.rar
http://rapidshare.com/files/49732099/bhav_data.part04.rar

Please change the floats to Curriecy and Timestamp to c(12) and delpercent to n(6,2)
tottrdqty to I


what i want to acomplish

set exclusive on

use bhav_data alias bhav in 0
select bhav
set order to tag dau asce
scan
select mton(open) from bhav_data where symbol = bhav.symbol into array aopen order by date
select mton(high) from bhav_data where symbol = bhav.symbol into array ahigh order by date
select mton(low) from bhav_data where symbol = bhav.symbol into array alow order by date
select mton(close) from bhav_data where symbol = bhav.symbol into array aclose order by date
select tottrdqty from bhav_data where symbol = bhav.symbol into array avolume order by date
select date from bhav_data where symbol = bhav.symbol into array adate order by date

* process the array adate,aopen,ahigh,alow,aclose,avolume in a FLL
*process the results from the fll

endscan


What is the fastest way ?

suhas