Write locally to disk, then batch insert to the database periodically (e.g. at log rollover time). Do that in a separate, low-priority process. More efficient and more robust… (Make sure that your database log table contains a column for “which machine the log event came from” by the way – very handy!)
Lose basicConfig() and use RotatingFileHandler: import logging from logging.handlers import RotatingFileHandler log_formatter = logging.Formatter(‘%(asctime)s %(levelname)s %(funcName)s(%(lineno)d) %(message)s’) logFile=”C:\\Temp\\log” my_handler = RotatingFileHandler(logFile, mode=”a”, maxBytes=5*1024*1024, backupCount=2, encoding=None, delay=0) my_handler.setFormatter(log_formatter) my_handler.setLevel(logging.INFO) app_log = logging.getLogger(‘root’) app_log.setLevel(logging.INFO) app_log.addHandler(my_handler) while True: app_log.info(“data”)