I'm planning to extend an application with logging of user events. (Client application via REST-API to Symfony). What is the preferred type of databases?
Currently the log data is stored in a relational database along with the rest of the data. Click events are to be stored as well. I suspect that a relational database would no longer be suitable for storing data sets in the range of a million.
Would it make more sense to use a non-relational database, or should I continue to work with the relational database and use the possibilities for the optimization of the requests(e.g. elasticsearch)? Since the relational database seems to work slowly for querying large amounts of data, would it be possible to have the data prepared in advance via cronjob stored in auxiliary tables?
The goal is to evaluate the log data for the user interface and to display different data in several charts.