General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Can you give us a bit more info Steve?... Like
1) What is the complete index expression?
2) What network software is in use?
3) How many concurrent users?
4) Is this in a 'production' CDX or an ancillary one?
5) The version of FP/VFP in use.
6) Anything else you think might be helpful.
Jim N
>I have an application which is heavily used on a network. The app is built around a table with 150,000+ records, and about 800 new records added every day.
>The table has 16 indexes in the cdx, and the primary index gets screwed up every day. What happens is that by the end of the day about 10 out of 800 records are missing (meaning if I set order to my primary index, they are not found, but all other indexes find them).
>Just for curiosity I added another index, same as my primary, and watched it for 3 days: this index is updated properly, nothing is missing, while my primary got screwed up again... I thought the problem is because of overuse, but I'm not sure.
>Does anybody knows how to deal with it?
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