Add index to your database (website, statuses, countries, date)
-
Hi, in Ati-spam log, I see “Internal Server Error” more often then real results.
The problem is probably in missing indexes in your database.
The problem occurs, when I do filter by combination of:
1) date range (customdates; problem is even for single day!)
2) + status (statuses = Denied)
3) website
4) countries (countries = Czech Republic)There is probably missing database index on this set of columns (website, statuses, countries, datetime?).
Please, could you check and fix your database structure?
The page I need help with: [log in to see the link]
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘Add index to your database (website, statuses, countries, date)’ is closed to new replies.