Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index With Disproportionate volume of data
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01038753
Message ID:
01039708
Views:
20
Hi Friends !

I created a Binary Index on DELETED() using the VP9 and used the command LOCATE FOR DELETED () to locate the first deleted register. I noticed that same using binary indexes the traffic in the net continues very big. My table has just 16000 registers and 5000 are deleted. I think the selectivity ratio is very bad one or I am making some wrong thing.

Everything what i desire is to use the recycling of registers, in other words, the registers are marked as deleted and when necessary I use the command recall to recover them without the need of using PACK.

Does anybody have some suggestion?

Thanks in advance,

[]´s

Dionísio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform