Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Very slow process
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00188801
Message ID:
00189125
Views:
10
Esteban,
Have you tried recycling the deleted records? Or, if they are temporary, packing them as Joseph suggested? Also, check that you have all the indexes you need if you are doing SELECTs. Check to see whether they are all fully optimized. Remember you will need indexes on deleted() if you have Set Deleted OFF.

HTH
Barbara

>Hi all,
>
>I have a process thet works OK.
>Sometimes this process is running for 3 or 4 days (because is very complex). The problem I have is after 2 days of processing time, my machine come very slow and Not Respond (but works). Windows process an event every 5 minutes.
>
>I think that the cause is that the temporary tables that I use in the process are never packed (this tables have no more than 200 records, but are continously appending and deleting records). Is this the posible cause???
>
>Thanks in advance!!!!
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform