Problem with very slow history database queries

There are several reasons why querying the history database is slow:

1. If they are being done from the Pandora FMS console: the connection between the console and the historical database is in another machine and there are connection problems between both of them.
2. Even in the own history database it takes a lot of time: this problem could be due to the fact that a correct cleaning of the history database is not being done by means of the pandora_DB tool. For this, you should configure this cleaning as it appears in the following link to our wiki:

https://pandorafms.com/manual/en/documentation/05_big_environments/07_server_management#setting_up_history_database_purge_and_compactation

If you see that this is not enough, you will have to perform more complex actions to make a better optimization of the database, for this you will have to follow the steps outlined in the following link to our wiki:

https://pandorafms.com/manual/en/documentation/05_big_environments/08_optimization