playSMS table indexes

anton · November 20, 2023, 1:35am

Hi,

I would like to know what do you think about these indexes:

playsms/playsms/blob/1.4.x-bd-updates/db/playsms-1.4.7-indexes.sql

-- 1.4.7

-- INDEX
ALTER TABLE playsms_tblUser ADD INDEX username (username);
ALTER TABLE playsms_tblBilling ADD INDEX uid (uid);
ALTER TABLE playsms_tblDLR ADD INDEX smslog_id (smslog_id);
ALTER TABLE playsms_tblDLR ADD INDEX uid (uid);
ALTER TABLE playsms_tblSMSOutgoing ADD INDEX smslog_id (smslog_id);
ALTER TABLE playsms_tblSMSOutgoing ADD INDEX uid (uid);
ALTER TABLE playsms_tblSMSOutgoing ADD INDEX queue_code (queue_code);
ALTER TABLE playsms_tblSMSOutgoing ADD INDEX p_datetime (p_datetime);
ALTER TABLE playsms_tblSMSOutgoing ADD INDEX p_smsc (p_smsc);
ALTER TABLE playsms_tblSMSOutgoing_queue ADD INDEX queue_code (queue_code);
ALTER TABLE playsms_tblSMSOutgoing_queue ADD INDEX flag (flag);
ALTER TABLE playsms_tblSMSOutgoing_queue ADD INDEX uid (uid);
ALTER TABLE playsms_tblSMSOutgoing_queue_dst ADD INDEX queue_id (queue_id);

For upcoming 1.4.7 I have updates, including above indexes applied, that speeds up report (Reports → All outgoing SMS), tested with demo database with 6 to about 12 million of records.

Thank you,
anton

Topic		Replies	Views
Playsms slow queries Help	2	173	December 1, 2023
playSMS 1.4.7 test version Dev	32	392	December 14, 2023
playSMS 1.4 has been released News	6	2285	September 16, 2016
Pruning the database Help	5	1161	July 5, 2016
Playsms 1.3.1 : fail to save in db table smslog_id Help	7	1254	November 19, 2019

playSMS table indexes

Related topics