Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Skip large number of records when Filter is in effect
Message
From
02/02/2000 01:41:41
 
 
To
02/02/2000 01:13:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00325473
Message ID:
00326002
Views:
23
>Try the following:
>
>local i
>select *, inc(@i) as rec_no from tmp1 where optimizedcondition;
> order by sortname into cursor tmp
>index on rec_no tag rec_no
>seek 50000


It seems like everything that I've tried causes two behaviors:

1. Slow select (with Nofilter or like code above)but fast skipping in resulting cursor

2. Fast select (without nofilter) but Slow skipping.

Also, i've noticed that the more records is under filter the faster is the skipping...
Huh, damn problem
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform