Performance Issues

Lukator uses MySQL. For some reasons we decided to insert lots of data into a table. Around 3.8 Mio entries. The table has proper indices on the fields we want to search. But still, a search for a specific GEO entry takes too long because so many rows fits the conditions even if the final result counts only a few rows. This means we have to find a solution and speed up the query. The current approach is to split the table into smaller pieces and to put a switch statement in front of the query. We want to fix this issue ASAP and continue afterwards with the open point shown in the status view.