Vladimir, I can understand why it can take VFP long to copy 800,000 records to a new temporary table (remember you are not using a remote view so you can have VFP "fetch as needed" and retrieve only small chunks of data) but does it take that long to retrieve 100 records another q. - what is the nature of the data in the table ? - if it is static data then you might consider SORTing the table on the Indexkey it can lower the retrieve time dramatically Arnon >Hello Arnon! > >This query may return from 100 till 700-800 thousand records. Don't think >that it's bad programming style, just testing of Rushmore power against >Delphi BDE. I'm still can't figure out what I'm doing wrong... > >Have a happy day >Vladimir Shevchenko > >> how many records are returned ? >> >Select * ; >> > from mytable; >> > where upper(myfield) > [SOMETHING]; >> >into cursor >> >then it going like turtle ;( (about 80-90 sec). I sure that this table > >