Hi Arife, DB status page shows RRC12 insertion reached middle of June 3d, so it's finally processing the old data faster than they originally came in (i.e. less than 24 hours work for 24 hours worth of updates). This gives hopes the rrc12 DBinsert will one day catch up with real time again :) Cheers, -- Rene On Mon, 12 Jun 2006, Arife Vural wrote:
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