Hello,
I'm trying to run this query more fastly. Can you help me how to optimalize it?
MariaDB [commonswiki_p]> select count(*) from logging_logindex where log_type="thanks" and log_title="Martin_Urbanec";
+----------+
| count(*) |
+----------+
| 6 |
+----------+
1 row in set (8 min 42.87 sec)
MariaDB [commonswiki_p]>
It's supposed to provide web-accessible information, and it's not possible to wait 8 mins for completion.
Any suggestions?
Martin