Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any ideas to index/speed this up?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00810823
Message ID:
00811057
Views:
8
Steve,

No code. You can email the code directly if you can't get it to post.

The index order is as follows, right?

01154351
0115435
01154
01154221
0115411
01154

And you have the FOR condition on your REPLACE, so each record only gets REPLACEd once, correct? Does your _TALLY after the REPLACE match the number of call records, or is it higher?


>For some reason it's not working in my program, when I just browse the files with the relation and indexes set as you recommended it appears to work right. I've tried every combination of index orders and still I keep ending up with only the shortest matches rated.
Previous
Reply
Map
View

Click here to load this message in the networking platform