Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INDEX TAG on DELETED() ......... HUMBUG
Message
 
To
16/03/1999 12:55:14
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00198031
Message ID:
00198223
Views:
20
Walter,

>> In my testing table of 1.900.000 records i've deleted about 19.000 records
>> and could not find any significant difference with or without the deleted() tag.

In this case the problem seems to be that the entire statement isn't optimized. Have you tried Sys(3054,1) to see the optimization level?

Markus




Markus Egger
President, EPS Software Corp
Author, Advanced Object Oriented Programming with VFP6
Publisher, CoDe Magazine
Microsoft MVP since 1995
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform