By default, LoggerFS automatically creates the specified table in the database using the TEXT datatype for all columns. Some users may find this negatively impacts the performance of their database, especially when dealing with hundreds of thousands of rows.
If you're at all familiar with database datatypes, you can overcome this performance obstacle yourself quite simply by creating the table yourself. You'll have to be careful; the column names must match those specified in the schemas.xml file and the data being inserted must be compatible with the column datatype, e.g. the apache file size parameter can be INTEGER, but not DATE.
By carefully choosing your datatypes, you can fairly dramatically increase the performance and reduce the size of your database.
Post new comment