Re: [sqlite] Performance issue using SQLite

2014-06-22 Thread lyx
CtrlFlag);" Thanks for Clemens' correction. Hi Clemens, I will try your advice and feed back the test result tomorrow. >Message: 5 >Date: Sat, 21 Jun 2014 21:53:58 +0800 >From: 163 >To: "sqlite-users@sqlite.org" >Subject: [sqlite] Performance issue using SQLit

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') or

[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 > ((PRODUCT_ID='%s