Re: [sqlite] how to break subquery into 2 simply query

pierr wrote: > Igor Tandetnik wrote: >> >> pierr wrote: >>> Following 2 statements took 400ms to be excuted on a 350M MIPS CPU >>> and it is a memory database: >>> >>> "DELETE FROM tblEvent_type WHERE eguid in (SELECT rowid FROM >>> tblEvent_basic WHERE sguid=11);"; >>> "DELETE FROM tblEvent_group

Re: [sqlite] how to break subquery into 2 simply query

Igor Tandetnik wrote: > > pierr wrote: >> Following 2 statements took 400ms to be excuted on a 350M MIPS CPU >> and it is a memory database: >> >> "DELETE FROM tblEvent_type WHERE eguid in (SELECT rowid FROM >> tblEvent_basic WHERE sguid=11);"; >> "DELETE FROM tblEvent_group WHERE eguid in (SEL

Re: [sqlite] how to break subquery into 2 simply query

pierr wrote: > Following 2 statements took 400ms to be excuted on a 350M MIPS CPU > and it is a memory database: > > "DELETE FROM tblEvent_type WHERE eguid in (SELECT rowid FROM > tblEvent_basic WHERE sguid=11);"; > "DELETE FROM tblEvent_group WHERE eguid in (SELECT rowid FROM > tblEvent_basic WHER

[sqlite] how to break subquery into 2 simply query

Following 2 statements took 400ms to be excuted on a 350M MIPS CPU and it is a memory database: "DELETE FROM tblEvent_type WHERE eguid in (SELECT rowid FROM tblEvent_basic WHERE sguid=11);"; "DELETE FROM tblEvent_group WHERE eguid in (SELECT rowid FROM tblEvent_basic WHERE sguid=11);"; (An inde