>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!!!!
Esteban,
Are you sure that they're so complex to take 3-4 days ? We had models running for more than a day and revised the code, now they finish in 55 mins max. Might you first think of this possibility.
For case of temp tables, most of them wouldn't be erased till you exit thus causing an increase in tempdir filecount. In turn it would cause increasing fileseek times and just for that reason your processing might come to an halt. IMHO continuous append, delete operations are both causes to slow down lengthy ops. If they're about 200 recs, instead of tables or cursors (though cursors are better than tables they use disk too) using arrays might dramatically cut down process time.
And yes all trial for these mean extra coding time and might prove no benefit :( but what if reverse :)
Cetin