Three or four days? WOW! What does it do (just a brief description to satisfy my curiousity)?
I would pack the tables periodically. Or do something like blank a record instead of deleting it and instead of adding records, fill-in the blanks ones (if there is a blank record). Whatever works in your situation. I would test different methods for efficiency.
Joe
>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!!!!
Joseph C. Kempel
Systems Analyst/Programmer
JNC