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!!!!