[Asterisk-Dev] Realtime mysql. IAX users registration.

[Dmitry Mishchenko]

Hello,

I'm playing with the latest asterisk and mysql realtime driver. I have another 
asterisk sending registration request every minute. Each request produce the 
following queries:
 
Dec 14 17:49:36 DEBUG[28109]: MySQL RealTime: Retrieve SQL: SELECT * FROM 
iaxfriends WHERE name = 'dima2'
Dec 14 17:49:36 DEBUG[28109]: MySQL RealTime: Everything is fine.
Dec 14 17:49:36 DEBUG[28109]: MySQL RealTime: Retrieve SQL: SELECT * FROM 
iaxfriends WHERE name = 'dima2'
Dec 14 17:49:36 DEBUG[28109]: MySQL RealTime: Everything is fine.
Dec 14 17:49:36 DEBUG[28109]: MySQL RealTime: Retrieve SQL: SELECT * FROM 
iaxfriends WHERE name = 'dima2'
Dec 14 17:49:36 DEBUG[28109]: MySQL RealTime: Everything is fine.
Dec 14 17:49:36 DEBUG[28109]: MySQL RealTime: Retrieve SQL: SELECT * FROM 
iaxfriends WHERE name = 'dima2'
Dec 14 17:49:36 DEBUG[28109]: MySQL RealTime: Everything is fine.
Dec 14 17:49:36 DEBUG[28109]: MySQL RealTime: Update SQL: UPDATE iaxfriends 
SET ipaddr = '127.0.0.1', port = '33528', regseconds = '1103039376' WHERE 
name = 'dima2'
Dec 14 17:49:36 DEBUG[28109]: MySQL RealTime: Everything is fine.
Dec 14 17:49:36 DEBUG[28109]: MySQL RealTime: Updated 1 rows on table: 
iaxfriends

Is it okay that one UPDATE preceed with four select statements? 
It seems to me retriving the same record 4 times is not optimal here. 
I'm not sure if its a mysql realtime driver problem or realtime usage in iax2 
channel.

Any comments?

Thanks,
Dima