yes you should create them by yourself.<br>We cannot guarantee the syntax to create indexes for each type of db.<br>We do make an effort to auto-create the table for you but if you are serious about it you may choose<br>to set the db up yourself.<br>
<br><br><div class="gmail_quote">On Sun, Apr 6, 2008 at 9:32 AM, kokoska rokoska <<a href="mailto:kokoska.rokoska@post.cz">kokoska.rokoska@post.cz</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Hi all again,<br>
<br>
I have just setted up ODBC connection to my MySQL DB and after it I look<br>
at tables created by Freeswitch and I see: There are no indexes.<br>
<br>
I'm not big DB guy, but I think that with even few thousands of rows<br>
(i.e. users) it will be much faster to do DB lookup based on indexes<br>
rather than on table fullscans.<br>
<br>
Am I missing something, or should I create indexes by myself? If yes, on<br>
what columns?<br>
Any comments are really welcome :-)<br>
<br>
Regards,<br>
<br>
kokoska.rokoska<br>
<br>
<br>
_______________________________________________<br>
Freeswitch-dev mailing list<br>
<a href="mailto:Freeswitch-dev@lists.freeswitch.org">Freeswitch-dev@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-dev" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-dev</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><br>ClueCon <a href="http://www.cluecon.com/">http://www.cluecon.com/</a><br>
<br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net">irc.freenode.net</a> #freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br><a href="http://iax:guest@conference.freeswitch.org/888">iax:guest@conference.freeswitch.org/888</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>pstn:213-799-1400