[Freeswitch-dev] sofia DB tables - missing indexes
anthony.minessale at gmail.com
Sun Apr 6 16:51:09 EDT 2008
yes you should create them by yourself.
We cannot guarantee the syntax to create indexes for each type of db.
We do make an effort to auto-create the table for you but if you are serious
about it you may choose
to set the db up yourself.
On Sun, Apr 6, 2008 at 9:32 AM, kokoska rokoska <kokoska.rokoska at post.cz>
> 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 :-)
> Freeswitch-dev mailing list
> Freeswitch-dev at lists.freeswitch.org
Anthony Minessale II
MSN:anthony_minessale at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
iax:guest at conference.freeswitch.org/888
googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Freeswitch-dev