Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
WAN and Visual FoxPro Database (Data Accessing speed)
Message
 
To
14/10/1999 10:10:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00276225
Message ID:
00276656
Views:
37
Jim,
I remember reading about this is FPA. If I recall, the article stated that having an index on deleted() when many records are deleted is slow, but having a deleted() tag when few records are deleted is appropriate. Is this what you got from the article?

Mark
>Dan,
>
>That key on Deleted() is no longer a good idea at all. It will almost surely HURT performance of a VFP application!
>
>Some say that it has always been this way, suggesting that we were all misinformed when this "tip" originally made the rounds. I happen to disagree with that opinion, but have no way to prove it one way or the other. Just to be clear, I have NO DOUBT that an INDEX on Deleted() will most likely HURT an app.; I doubt that it has always been this way.
>
>Cheers,
>
>Jim N
>
>
>
>>Make sure the program is installed and running from the local machines.
>>Make sure you're useing buffering. Make sure you're views are optimized sys(3054). Make sure you have a key on Deleted() on all your tables.
>>
>>You can also use coverage logging in the Debugger or just step through the program yourself to see which lines are so slow.
>>
>>HTH
Mark Achin
Independent Consultant, VFP MCP
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform