This is definitely the fastest way, if it succeeds. If its performed via SQLite DDL then it does the appropriate locking on the file etc and returns nice error codes.
By doing it via the file system (at least on linux), other readers of the file will continue to read from it... I don't know if they are allowed to write to it... In either case it doesn't seem appropriate to me. If your on windows the remove request could even fail if you or others have the file open... It may be slower, but you probably want to drop the tables via sqlite ddl. --paul On 2/9/06, Xavier Noria <[EMAIL PROTECTED]> wrote: > > On Feb 9, 2006, at 23:02, Marian Olteanu wrote: > > > I would say that the fastest way (CPU cycles and lines of code) to > > delete all tables would be to delete the file in which the database > > is stored. > > Clever! > >
