Different time spent in Windows and Linux
I have a task, where I read a text file, parse it and save some contents in SQLite database. So there are only write-operations to database. In Windows this task is performed in 75 seconds. In Linux - in 15 minutes. Profiling of code displays that database operations take 90% of all task time. Are there any suggestions about what settings in the SQLite can cause such a catastrophic difference in times?
It may be that the file-system on Windows is not syncing to disk when asked to, whereas Linux is.
Grouping your write operations into a transaction or transactions should help.