MySQL DLR

Hello folks,

For those of you who use mysql delivery reports, here's the 
definition of the standard table. I added indexes to this as 
otherwhise your system becomes suddendly very slow if you forget 
them. Happened to me with 80'000 records in the DLR database the 
speed was dropping to 3-4msg/sec where it should be 15-20msg sec. So 
if you havnt thought of indexes in the DLR table, add them. It makes 
a big difference!


#
# Table structure for table 'DLR'
#

CREATE TABLE DLR (
   smsc varchar(40) default NULL,
   ts varchar(40) default NULL,
   destination varchar(40) default NULL,
   service varchar(40) default NULL,
   url varchar(255) default NULL,
   mask int(10) default NULL,
   status int(10) default NULL,
   stext varchar(255) default NULL,
   KEY smsc_idx (smsc),
   KEY ts_idx (ts),
   KEY destination_idx (destination),
   KEY service_idx (service),
   KEY url_idx (url),
   KEY mask_idx (mask),
   KEY status_idx (status),
   KEY stext_idx (stext)
) TYPE=MyISAM;


-- 

Andreas Fink
Fink-Consulting

------------------------------------------------------------------
Tel: +41-61-6932730 Fax: +41-61-6932729  Mobile: +41-79-2457333
Address: A. Fink, Schwarzwaldallee 16, 4058 Basel, Switzerland
E-Mail:  [email protected]  Homepage: http://www.finkconsulting.com
------------------------------------------------------------------
Something urgent? Try http://www.smsrelay.com/  Nickname afink