[sqlite] Is it faster with descending index

2016-05-06 Thread Ertan Küçükoğlu
an K???ko?lu -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Friday, May 6, 2016 12:51 AM To: SQLite mailing list Subject: Re: [sqlite] Is it faster with descending index On 5/

[sqlite] Is it faster with descending index

2016-05-06 Thread Ertan Küçükoğlu
Hi, I am using SQLite version 3.9.2 on WinCE devices. I have below table in one of my databases. Table sometimes holds 1.5 to 3 million records in it. That database is reached for read-only purposes and created from scratch in a PC if its contents needs to be updated. All database files, applicati

[sqlite] Is it faster with descending index

2016-05-05 Thread Richard Hipp
On 5/5/16, Ertan K???ko?lu wrote: > > Table create SQL: > CREATE TABLE URUN( > Barkod Char(30) NOT NULL PRIMARY KEY, > ... > ); > > My question is, if I add following index, will it make my searches faster? > > CREATE UNIQUE INDEX IDX_BARKOD_DESC ON URUN(BARKOD); No. But if you change your tab