[Asterisk-Users] cdr_mysql - would index slow down?

[Roger Schreiter]

Hi,

I intend to change the cdr_mysql-field "uniqueid",
which seems not to be used so far, to an (not unique)
indexed field and use it later for my own hints and infos.

I don't have very much traffic so far, and I wonder,
if there will appear problems when asterisk is under high
load (100 simultanious calls) and the log table contains
1.000.000 log lines.

This would mean, that asterisk would have to wait some
time when writing a log line, because mysql has to update
the index.

Can anyone with some more experience predict, whether
there will be problems cause to the indexed field?


Your opinion is welcome!
Roger.