jeudi 19 septembre 2019

Single vs bulk insert of logs in web

In a project i'm currently working on, a very complex process is taking place with tons of logs (in debug mode). Every log is written to the database in a single transaction, and I've noticed some performance issues when debug mode is on.

An idea came to me, to add all the logs to a static list (generated per request, for the life time of the request), and than bulk insert them to SQL.

I'm not sure weather I'm using the right terminology here, but I couldn't really find anything online.

Is it a good idea bulk inserting logs like this? Should I implement this?




Aucun commentaire:

Enregistrer un commentaire