>Do you have a specific SQL or xBAse code causing headache?

ya,
it is realated to code like this.


create table bhav_data.dbf free ;
(symbol c(20),series c(20),open f(20,2),high f(20,2),low f(20,2),close f(20,2),;
last f(20,2),prevclose f(20,2),tottrdqty f(20,2),tottrdval f(20,2),timestamp c(20),date d,delqty i,delpercent f(20,2))


with records 260000+

and indexed on timestamp

but this takes ages to complete on my laptop but on a less faster config it runs under .9 secs

select dist timestamp from bhav_data into cursor test nofilter

laptop AMD athlon XP prosser 1400 + ,128mbram,a damn slow hdd
test mach . amd k6 500mhz 256mbram 5600rpm 40gb hdd.

SO it gives more headachs on using SQL on that mach. where as the XBASE completes in 0.2 sec

like this

create test(t1 c(20))
index on t1 tag t1
select bhav_data
scan for !seek(timestamp,'test','t1')
insert into test values(bhav_data.timestamp)
endscan

As for the other mach. SQL runs under 1 sec so my laptop is the problem.

thanx
suhashegde