[Freeswitch-dev] sofia DB tables - missing indexes

Anthony Minessale 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 :-)
> Regards,
> kokoska.rokoska
> _______________________________________________
> Freeswitch-dev mailing list
> Freeswitch-dev at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev
> http://www.freeswitch.org

Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/

AIM: anthm
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...
URL: http://lists.freeswitch.org/pipermail/freeswitch-dev/attachments/20080406/8b2ac13f/attachment.html 

More information about the Freeswitch-dev mailing list