Re: [sqlite] DROP TABLE slower than DELETE?

2007-04-19 Thread drh
Guy Hindell <[EMAIL PROTECTED]> wrote: > > In promoting SQLite 3 (still v3.2.7, so a bit behind the current > release) for a new project I have been doing some performance tests and > SQLite generally looks very good. However, I have seen one surprising > result. > > My schema is simple, a

[sqlite] DROP TABLE slower than DELETE?

2007-04-19 Thread Guy Hindell
Hi all In promoting SQLite 3 (still v3.2.7, so a bit behind the current release) for a new project I have been doing some performance tests and SQLite generally looks very good. However, I have seen one surprising result. My schema is simple, a single table with a simple autoincrement rowid