Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimizing a View/SQL-Select
Message
From
21/11/2000 10:35:18
Walter Meester
HoogkarspelNetherlands
 
 
To
21/11/2000 09:09:55
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00443643
Message ID:
00444130
Views:
10
Hi John,

You don't have to remove the delete records inmediately. When after a while large amounts of deleted records exists, then issue a pack.

When recycling records you might be better of with a index constructed with:

INDEX ON .T. FOR DELETED() TAG Del

This one never gets used by rushmore and is smaller than the DELETED() TAG because it only contains nodes for actual deleted records.

You can simply search for a deleted record with:
SEEK(.t.,CYourAlias,"Del")

Walter,


>Hi Walter,
>
>If you are not recycling records on a networkable application (I use a deleted() tag to do this) when do you remove the deleted records? My applications are all end user types rather than corp type. My selects are slow and I think that the deleted tag may be the problem...
>
>Thanks
>
Previous
Reply
Map
View

Click here to load this message in the networking platform