readmode table gets updated on frequently basis so i can not create index on
it.
Is there any way out except create index on it.
Pavel Ivanov-2 wrote:
>
>> Why not just make epc column "unique on conflict ignore"?
>> i.e.
>> CREATE TABLE readmode( epc text unique on conflict ignore, col2 text...
>> );
>>
>>> one EPC ( say:'e2003411b802010994095761' i.e. 24char ) out of 5000
>>> records.
>>> and select query take 2-3 sec. to give result output.
>>>
>>> By any means i can reduce this search time with EPC as search criteria.
>
> If you don't want to make it unique at table definition then create an
> index on it ('unique' constraint creates an index for you) - it will
> speed up any searches on EPC.
>
>
> Pavel
>
> On Tue, Dec 15, 2009 at 4:54 AM, Simon Davies
> <[email protected]> wrote:
>> 2009/12/15 Ram Mandavkar <[email protected]>:
>>>
>>> Hello All,
>>>
>>> I am New to SQL-Lite DB,
>>> I had one ASSET table having EPC as varchar(50) field and 5000 records
>>> in
>>> it.
>>>
>>> If i want to search
>>> (
>>> CREATE TRIGGER "main"."TR_MULTIREAD_BEFORE" BEFORE INSERT ON READMODE
>>> BEGIN
>>> SELECT CASE
>>> WHEN M.a = NEW.EPC THEN RAISE( IGNORE )
>>> ELSE 1
>>> END
>>> FROM
>>> ( SELECT EPC AS a FROM READMODE where EPC=NEW.EPC ) AS M;
>>> END
>>> )
>>
>> Why not just make epc column "unique on conflict ignore"?
>> i.e.
>> CREATE TABLE readmode( epc text unique on conflict ignore, col2 text...
>> );
>>
>>> one EPC ( say:'e2003411b802010994095761' i.e. 24char ) out of 5000
>>> records.
>>> and select query take 2-3 sec. to give result output.
>>>
>>> By any means i can reduce this search time with EPC as search criteria.
>>>
>>> Regards
>>>
>>
>> Regards,
>> Simon
>> _______________________________________________
>> sqlite-users mailing list
>> [email protected]
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/EPC-Based-Search-tp26791835p26810582.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
