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
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')
> 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
>
3 matches
Mail list logo