Playsms slow queries

playSMS Help
1

Hello friend
I’m using playsms with about 2000users.
I have some problem with MySQL queries.
Playsms is very very low speed to phonebook access or sent message access or welcome page.

I recently install latest version of playsms in new clean server and restore my DB. ( My playsms DB size is about 1GB ) and it’s very slow. (Clean playsms core with my huge db)

How can I fix it.
It’s trouble slow.

Thx.

2 
> # User@Host: admin[admin] @ localhost []
> # Thread_id: 14509  Schema: playsms  QC_hit: No
> # Query_time: 14.548385  Lock_time: 0.000184  Rows_sent: 50  Rows_examined: 4664360
> SET timestamp=1693628346;
> SELECT DISTINCT A.id AS pid, A.uid AS uid, A.name AS name, A.c_timestamp AS c_timestamp, A.mobile AS mobile, A.comment AS comment, A.voting AS voting, A.nov AS nov, A.first_visit AS first_visit, A.birthday as birthday,A.customer as customer, A.email AS email, A.tags AS tags FROM playsms_featurePhonebook AS A LEFT JOIN playsms_featurePhonebook_group_contacts AS C ON A.id=C.pid LEFT JOIN playsms_featurePhonebook_group AS B ON B.id=C.gpid  WHERE  ( A.uid='1990' OR B.id in (
>                                 SELECT B.id AS id FROM playsms_featurePhonebook AS A
>                                 LEFT JOIN playsms_featurePhonebook_group_contacts AS C ON A.id=C.pid LEFT JOIN playsms_featurePhonebook_group AS B ON B.id=C.gpid
>                                 WHERE A.mobile LIKE '%1211211'
>                                 AND B.flag_sender='1'
>                                 ) OR ( A.uid <>'1990' AND B.flag_sender>'1' ) ) AND '1'='1' ORDER BY DATE(A.c_timestamp) DESC, TIME(A.c_timestamp) DESC LIMIT 50 OFFSET 0;

one of my slow queries

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.