Hello. I am connecting SQLite database through shared folder from application written with C# using “System.Data.SQLite.dll” When doing partial match searching from 300,000 records with just one PC connected to the network, it takes less than one second for the query result to be returned. But when connecting to the same database with another PCs, it takes about 12 seconds to have query result to return. If index search (fully matched, prefix or the beginning match) is used, multiple connections will have no problem with its speed. We have tested and confirmed that result. The speed will somewhat improve if all PC is disconnected once for each query, but since there is another problem that it takes too much time to cache the index on the first query, I’d like to have it keep connected until the application is finishes. Are there any ways to avoid having speed declining when non-index search are done while connected to database with multiple connection from the network?
I gave SQLite Connection the following connect string: Data Source="test.db";Pooling=false;FailIfMissing=false;Journal Mode=Default;Synchronous=Normal Motonari _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
