Hello, Thanks for your response. What are the fields that should be indexed?
On Fri, Mar 23, 2012 at 12:54 AM, spameden <spame...@gmail.com> wrote: > We are using InnoDB. It works just fine with dlr and send_sms, sent_sms > tables. InnoDB comparing to MyISAM is more fault proof, so I'd recommend > using it, every insert is a transaction, so theoritacally you won't lose > more than 1 transaction if something bad happens. > > Don't forget to add relevant indexes for speeding up queries from dlr > table. > > > 2012/3/22 Ashish Agarwal <ashisha...@gmail.com> > >> Hello, >> >> I wish to know what is the suitable mysql engine(MYISAM or INNODB) for >> dlr and sqlbox (send_sms and sent_sms table) from kannel. I currently have >> high load of traffic and RAM is not a problem. >> >> Please suggest. >> >> -- >> Regards, >> >> Ashish >> > > -- Regards, Ashish Agarwal
