On 12 May 2015, at 9:33am, Zaumseil Ren? <RZaumseil at kkg.ch> wrote:
> My main problem is still the time of a delete statement. It takes some > minutes to delete all data from all tables. How many tables do you have ? You are using just the command DELETE FROM myTable with WHERE clause ? > May be it is also a hardware problem. I found recently a thread about > disabling indexing on windows directories. I will try this and play with the > sqlite settings. > > I also tried to recreate the database. It failed sometimes because after "db > close" I could not always delete the file. Windows gave a permission denied. > And then you also run in problems when the database is read from other > processes. This is usually the result of antivirus software. When you close the database the antivirus program thinks a change has been made to the database file so it immediately starts scanning it. It is still scanning the file when you try to delete it, so Windows refuses to delete the file because a program is still reading it. Simon.
