>> 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 >
I have up to 3000 Tables. Most of them have only some entries. But some can have have up to a million. >DELETE FROM myTable > >with WHERE clause ? I use the simple "delete from tablename" > >> 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. > yeah, I suspect something like that. >Simon. Thank you Rene Kernkraftwerk Goesgen-Daeniken AG CH-4658 Daeniken, Switzerland Diese Nachricht (inkl. Anhaenge) beinhaltet moeglicherweise vertrauliche oder gesetzlich geschuetzte Daten oder Informationen. Zum Empfang derselben ist (sind) ausschliesslich die genannte(n) Person(en) bestimmt. Falls Sie diese Nachricht irrtuemlicherweise erreicht hat, sind Sie hoeflich gebeten, diese unter Ausschluss jeder Reproduktion zu vernichten und den Absender umgehend zu benachrichtigen. Besten Dank.
