Thank you for the good suggestions. I've been applying them to a smaller subset of my database to see how it might perform.
I had tried fiddling with the cache size but it seemed to make performance slightly degrade in my case. In principle it should work, so perhaps my smaller database isn't entirely representative of the larger one. I will test it out fully later. However, the threading pragma is showing a pretty dramatic (3-4x increase in speed) improvement, so I think this will be a huge benefit. For some reason I had overlooked that setting. The attach limit looks like it would be good to try at some point. I am using Windows, but unfortunately I am preparing this database for use in a tool that will be shared with other installations/operating systems. In order to keep it extremely simple for the end user, I'm sticking to whatever I can rig through the pre-compiled Python version, but for my own personal projects I will try to fiddle with attach. The ability to split the database into multiple files will come in handy if I end up tackling anything larger. -AJ -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
