Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why this DELETE is so slow?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00988740
Message ID:
00988774
Views:
29
How many records are deleted by this command?

>Actually this is what I see:
>
>Open 1st instance of VFP
>Execute DELETE - runs fast
>
>Open 2nd instance of VFP
>USE the 2 tables
>
>Back into the 1st instance
>Execute DELETE - slow
>
>Close the 2nd
>In the 1st run DELETE - slow !!!
>Reopen tables
>Run Delete again - fast
>
>What's going on?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform