The version of SQLite I'm using is the NuGet package System.Data.SQLite (x86/x64) v1.0.97.0
I tried loading the data in several queries with a cache, but performance was worse and it added several problems, such as the inability to sort using these calculated columns! That's not an option. I have to run it all at once. Etienne