search

minimus / simple-ads-manager

Advertisement rotation system for Wordpress with a flexible logic of displaying advertisements.
16 stars 15 forks source link

No indices on sam_stats table. #25

Open untone-survive opened 9 years ago

untone-survive commented 9 years ago

I don't know if this is a error in my install but there are no inidices in sam_stats table, and the "Ads Places" page in the Dashboard takes ages to load. 38 seconds for one query in mysql-slow log.

The query is in list.admin.class.php starting on line 200.

I've added inices for the table manually and it became quicker - 8 seconds. But still it's long enough.

ellocofray commented 9 years ago

Same here. I had to disable stats completely because sam_stats gets humongous. Perhaps some sort of scheduled resume is in order... Other option might be moving historical data to other table and avoid joining it ever time. Thoths