Strange query

[DARKF3D3]

In slow quey log of my site i see this strange query that has examined over 180000 rows.

Is this normal?

# Thu Mar 10 06:02:14 2011
# Query_time: 8.307048  Lock_time: 1.372453 Rows_sent: 1  Rows_examined: 189305
use crazyluk_prestashop;
SELECT COUNT(DISTINCT cp.`id_connections`)
       FROM `ps_connections_page` cp
       WHERE TIME_TO_SEC(TIMEDIFF(NOW(), cp.`time_start`)) < 900 LIMIT 1

[DARKF3D3]

No one know what could be this query?

[jacky75]

It's the statshome module

[DARKF3D3]

It's the statshome module

But it is normal that examines over 180000 rows?
What is need for that module?

[jacky75]

That module it's about the statistics shown on the back office home page. If you can, disable or uninstall that module. In the first case the database will not be deleted, so you could restart those statistics. For sure, if you need statistics about accesses etc.. you could use Google analytics thought the specific Prestashop modules.

[DARKF3D3]

If i uninstall that module the google analytics stats continue to working?

[jacky75]

"Google Analytics " and the BO home stats are two different modules, so you can switch off only the second one. To avoid big issue, instead of uninstalling the module, you could start disabling it. Thus you could check the platform behavior for some days and then, if you want, you could uninstall it or enable it again. For sure, in the last case you should check if it's possible to clean the database because the involved query is about a too big table.