Re: [sqlite] Performance issue using SQLite

2014-06-22 Thread lyx
Jun 2014 21:53:58 +0800 >From: 163 <sdu...@163.com> >To: "sqlite-users@sqlite.org" <sqlite-users@sqlite.org> >Subject: [sqlite] Performance issue using SQLite >Message-ID: <790e34bd-c627-4dd6-872e-2b358a6d1...@163.com> >Content-Type: text/plain; char

Re: [sqlite] Performance issue using SQLite

2014-06-21 Thread Clemens Ladisch
163 wrote: > I met a performance issue when using SQLite 3.8.4.3. I found it would > be quite slow trying to select count(*) using a where statement with > several OR condition. For example: > > select ctrl_no from T_CTRL_CLRRULE where CTRL_NO='%s' and ((PRODUCT_ID='%s' > and OPERATE_TYPE='%s')

[sqlite] Performance issue using SQLite

2014-06-21 Thread 163
> Hi Experts, > I met a performance issue when using SQLite 3.8.4.3. I found it would be > quite slow trying to select count(*) using a where statement with several OR > condition. For example: > > sprintf (sql_str, "select ctrl_no from T_CTRL_CLRRULE where CTRL_NO='%s' and >