I'm working on some offline development and I'm hitting some pretty abysmal performance issues using the .net runtime API. The application is using the SQLite file and loaded on the map. the very first day when the application is loading it, this is fast but the next day when I use the same SQLite file it's using a lot of time to render on the map.
SQLite file is WAL enabled and I observed the next day it updates the shm file. When layers are rendering on the map and I do zoom-in and zoom-out I see very strange behavior.
even If I made the direct connection to SQLite and execute some query, it's taking a long time.