Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create index on Local Views...
Message
From
10/09/2004 07:47:27
 
 
To
09/09/2004 09:03:50
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00938374
Message ID:
00940982
Views:
25
>
>That's what Mike is saying. I have to admit I've nevere actually timed it. From having done it both ways in various programs, It's always seemed to me to be faster doing it the say I said. Mike's code shows it to be the other way around. The actual timing shows that it's faster to load the data first and then index. It's weird because, not only has it seemed faster to me to do it the other way, but it's seemed to be a LOT faster.
>
>Time to change some code.
>
>Alan

Hi
If you are not yet fed up with testing you can run Mike's code only the receipient of records is a view. I say this because i found in my e-books advice exactly like that you gave about view indexing.
Kamil
A moment of silence is our cosmic reset button.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform