[Freeswitch-dev] sofia DB tables - missing indexes

kokoska rokoska kokoska.rokoska at post.cz
Sun Apr 6 10:32:31 EDT 2008


Hi all again,

I have just setted up ODBC connection to my MySQL DB and after it I look 
at tables created by Freeswitch and I see: There are no indexes.

I'm not big DB guy, but I think that with even few thousands of rows 
(i.e. users) it will be much faster to do DB lookup based on indexes 
rather than on table fullscans.

Am I missing something, or should I create indexes by myself? If yes, on 
what columns?
Any comments are really welcome :-)

Regards,

kokoska.rokoska




More information about the Freeswitch-dev mailing list