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
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org
pstn:213-799-1400