[Freeswitch-dev] sofia DB tables - missing indexes

[Anthony Minessale]

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>
wrote:

>
> 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>
pstn:213-799-1400
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-dev/attachments/20080406/8b2ac13f/attachment.html