On 12/14/2011 12:24 PM, Uri Shacked wrote:

OK,

If for example I loaded at startup 30K raws.

Then, after 5 min 20 raws needs to change...

I truncate the carrierroute table, populate it again with 20 raws onlye and reload....

what about the others? they will be gone right?

Hello,

Yes, the new loaded carrierroute will contain only 20 raws. Instead of truncate/insert do an update on the 20 rows and and a cr_reload fifo command.

Marius

-- 
Zbihlei Marius

Head of
Linux Development Services Romania

1&1 Internet Development srl    Tel KA: 754-9512
Str Mircea Eliade 18            Tel RO: +40-31-223-9512
Sect 1, Bucuresti               mailto: marius.zbihlei@1and1.ro
71295, Romania