Hi! Here is a patch to use INSERT ... ON DUPLICATE KEY UPDATE instead of just UPDATE. This increases the performance by an order of magnitude with MySQL. This relies on the fact that the WHERE clause is equivalent to the primary key.
There is no option for this because it supported by MySQL since ages. There also a side fix because on 64 bit arch, %lu is for a long int which is usually not uint32_t. printf should use PRIu64 and PRIu32. _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists