I skipped the data for April and May, and restarted Dbinsert from the begining of this month. Also run few optimize/reapir on mostly used SQL tables. It looks SQL queries are running in reasonable speed. Will keep an eye on it. On Mon, Jun 12, 2006 at 02:54:31PM +0200, Henk Uijterwaal wrote:
Hi,
It might be worth flagging some of these old files as 'AI' or 'RI' in the updtlist table so that dbinsert will skip them and then gradually move them back to 'A'/'R' as processing time permits.
I think this is a good idea. Recent data with a hole in April/May is probably more useful than no data from June.
Henk
James
------------------------------------------------------------------------------ Henk Uijterwaal Email: henk.uijterwaal(at)ripe.net RIPE Network Coordination Centre http://www.amsterdamned.org/~henk P.O.Box 10096 Singel 258 Phone: +31.20.5354414 1001 EB Amsterdam 1016 AB Amsterdam Fax: +31.20.5354445 The Netherlands The Netherlands Mobile: +31.6.55861746 ------------------------------------------------------------------------------
1160438400. Watch this space...
-- Arife Vural SED, RIPE NCC