General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>
>>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
After Mike's message, I did run a couple of tests on some of my real data, and sure enough, it works exactly in the reverse to what I had thought. The difference isn't much, but it's there. As I update my apps in the regular course of maintenance and improvement, I'll be changing the way I've been handling it. The coding changes aren't significant thank goodness.
Alan
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