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@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@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@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400