hello, No question, just some information that might be useful to someone.
We have a number of small SQLite databases, which are located on a network drive. Users are complaining the last months that these databases becomes slower every week. After investigating the case, we found that Sophos anti-virus software is causing this problem. The standard setting of Sophos is to scan on each file read, so every simple query to the database loads the whole database file to the local system for virus scanning. The data transport when Sophos is on is about 300 times larger than in normal use. After disabling Sophos for the SQLite database files, the system runs like a speer. cheers, Stef _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users