playSMS Forum

Billing table deletion of records

Is is safe if you are using billing to delete the entries from playsms_tblBilling as it takes a while to update once the tables has a lot of rows in it.

Hi,

No, tblBilling used to calculate credit unfortunately.

anton

Thanks, so if I make a note of the current credit delete the records and empty the balance on the tblUser and reinstate the credit will be the only way around this ? or will running a rebuild of the table make it quicker like OPTIMIZE TABLE tblBilling.

probably adding a way to “archive” old data entries will be better

currently that table is used to calculate credit, if you remove entries then credits will returns

I haven’t test your way but should work. use docker playsms for quick test on your laptop/pc, configure rate, send some tests message and see credits and tblBilling, and continue with your test

anton

Thanks as usual for you quick reply.