<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> <tt>Hi, Frassinelli, Marco wrote the following on 17.09.2009 17:11:<o:p></o:p></tt> <blockquote cite="mid:F67BD758D4C6ED4B9BE7730A3D78A91C025B2A20@derum202.emea.corp.eds.com" type="cite"> <div class="Section1"> <tt><o:p> </o:p></tt> <tt> ndo2db_db_clear_table(idi,ndo2db_db_tablenames[NDO2DB_DBTABLE_PROGRAMSTATUS]);<o:p></o:p></tt> <tt> ndo2db_db_clear_table(idi,ndo2db_db_tablenames[NDO2DB_DBTABLE_HOSTSTATUS]);<o:p></o:p></tt> <tt> ndo2db_db_clear_table(idi,ndo2db_db_tablenames[NDO2DB_DBTABLE_SERVICESTATUS]);</tt> </div> </blockquote> <tt>What makes you believe that this cleanup is wrong? Did you do a deeper look at the conditional statement above which makes sure that old data compared to real time data won't stay in the database? Of course, it causes a heavy load on the database throwing big delete statements. Worst case scenario, that the queries take too long and everythings screws up. Kind regards, Michael </tt> <pre class="moz-signature" cols="72"><tt>-- DI (FH) Michael Friedrich <a class="moz-txt-link-abbreviated" href="mailto:michael.friedrich@univie.ac.at">michael.friedrich@univie.ac.at</a> Tel: +43 1 4277 14359 Vienna University Computer Center Universitaetsstrasse 7 A-1010 Vienna, Austria </tt></pre> </body> </html>