Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
Hi CY,
>And a caviat recently found. If you have index tags on deleted() on your tables, Access has trouble dealing with the tables (sometimes).
>We have such a tag on EVERY table in our product,
Why ???
those indexes on tables actually have bad influence on performance in the vast majority of cases. It is a common mistake to think that an index on DELETED() would speed things up.
>I have also seen some benchmarks in either Foxpro Advisor or Foxtalk (can't remember which right now) that imply that having a tag on deleted() may actually slow queries down unless you have a LOT of deleted records in your data all the time.
FPA may issue. And they're right. You'll probably will improve performance of your application if you'll omit them. If it runs on slower networks, the performance gains might be tremendous.
Walter,
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