General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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