log matches

[webzunft]

log queries, patterns and variables in its own table so admins can review it to optimized the results
make it optional to log the results, so for performance reasons or if everything is right, logging is disabled

[wprj]

Understood.

[wprj]

I wonder if writing to a text file is not faster. csv format for eg?

[webzunft]

from what I know, writing to a text file (the hard drive) takes more ressources
@goatherd any argument for text file or db for a simple log?

[wprj]

After a few searches on google, it seems that the performance of this two methods depends mainly on the server's general performance and the size of the data to be stored/read.

But in summary, the profitability of the use of a DB increases with the amount of data.

And, as the plugin will edit the log data for each query, it is more than probable that two or more requests happen at approximately the same time. If we use a text/raw file, we will have to handle this specific case (and may be some others).

[webzunft]

since there will be a lot of data when log is enabled, please use a database