Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SEEK(),INDEXSEEK() or KeyMatch() or SELECT-SQL?
Message
 
 
To
14/04/2005 12:25:08
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01002645
Message ID:
01004729
Views:
35
>Hi Nadya,
>
>>I just tried it. To replace value with 50000 records (the same value to the same value) it originally took 91 sec. and now it's 35 sec., with native RI is taking 51 sec. That's definitely a huge improvement.
>
>Well, that is nearly all for that approach: there are still a few ms hiding, but not enough to ferry out.
>But remember that I sent you this code cold: just visualizing the data flow for the RIDef-Table and some inspired line cutting. There is at least one lcTag undefined AFAIR... Not production quality yet ;-)
>
>Build a few test cases for other operations as well and keep me informed about the numbers. Also pls. check your company mail acount: don't worry, it is not a bill...
>
>regards
>
>thomas
I re-ran it again and now it takes 87 sec. for 50000 recs. Did I do something bad again? It's like 1 step forward and 2 backwards... :( And I hadn't yet tested everything in my test database.

I did a test with my TEST database first using yesterday's code. It took 13 sec. Then with today's code. It took 17 sec. I guess, I'm running in the wrong direction...
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform