General information
Category:
Forms & Form designer
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
>
>
Previous
Next
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