Re: [sqlite] Re: How to improve performance of SQL DELETE

Am 19.04.2006 um 14:08 schrieb Igor Tandetnik: Kai Wu <[EMAIL PROTECTED]> wrote: 2. The table schema is simple TABLE MID(id VARCHAR(8),scts VARCHAR(12),daddr VARCHAR(20)) the scenario is it needs first select the "id" by select id from MID where scts= .. AND daddr=... after t

[sqlite] Re: How to improve performance of SQL DELETE

Kai Wu <[EMAIL PROTECTED]> wrote: 2. The table schema is simple TABLE MID(id VARCHAR(8),scts VARCHAR(12),daddr VARCHAR(20)) the scenario is it needs first select the "id" by select id from MID where scts= .. AND daddr=... after the id field is retrieved, this entry can be delete