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	138	December 1, 2023
Database Cleanup script Help	0	359	May 31, 2020
Inviting interested testers on billing issue Dev	6	1644	June 13, 2016
Changelog PlaySMS 1.5-dev Dev	1	1102	June 30, 2018
Tests reports welcome? Help	3	362	May 30, 2021

playSMS table indexes

Related Topics