Re: [sqlite] Huge Table with only one field -- efficient way to create index ?

2009-11-26 Thread Thomas Lenders
Simon Slavin schrieb: > On 26 Nov 2009, at 2:50pm, Thomas Lenders wrote: > > >> I am looking for an exact match as in I need to know if a number exists >> in the table or not. >> Something like "select count(*) from ART where artnr='0123456789'". >> >> I could store the data in a text file

Re: [sqlite] Huge Table with only one field -- efficient way to create index ?

2009-11-26 Thread Simon Slavin
On 26 Nov 2009, at 2:50pm, Thomas Lenders wrote: > I am looking for an exact match as in I need to know if a number exists > in the table or not. > Something like "select count(*) from ART where artnr='0123456789'". > > I could store the data in a text file instead but then I would have to >

Re: [sqlite] Huge Table with only one field -- efficient way to create index ?

2009-11-26 Thread Igor Tandetnik
Thomas Lenders wrote: > I tried creating the field as INTEGER, but 10 digit numbers where > imported as 0. SQLite uses 64-bit integers, for about 19 decimal digits. The problem must be with the software that populates the table. > I assume the field was created as 32 bit integer and invalid

Re: [sqlite] Huge Table with only one field -- efficient way to create index ?

2009-11-26 Thread Thomas Lenders
Hi Nick. Yes, actually that leads me to another question. :) I tried creating the field as INTEGER, but 10 digit numbers where imported as 0. I assume the field was created as 32 bit integer and invalid entries got a default value. I also tried LONGINT, BIGINT and INT64 but no joy. What would

Re: [sqlite] Huge Table with only one field -- efficient way to create index ?

2009-11-26 Thread Nick Shaw
Lenders Sent: 26 November 2009 14:50 To: General Discussion of SQLite Database Subject: Re: [sqlite] Huge Table with only one field -- efficient way to create index ? Simon Slavin schrieb: > On 26 Nov 2009, at 2:04pm, Thomas Lenders wrote: > > >> I am using SQLite on a mobile devic

Re: [sqlite] Huge Table with only one field -- efficient way to create index ?

2009-11-26 Thread Thomas Lenders
Simon Slavin schrieb: > On 26 Nov 2009, at 2:04pm, Thomas Lenders wrote: > > >> I am using SQLite on a mobile device. >> >> I have this one table which has only one field, but I need to search in >> the table very quickly. >> When creating an index on this field the size of the database is

Re: [sqlite] Huge Table with only one field -- efficient way to create index ?

2009-11-26 Thread Simon Slavin
On 26 Nov 2009, at 2:04pm, Thomas Lenders wrote: > I am using SQLite on a mobile device. > > I have this one table which has only one field, but I need to search in > the table very quickly. > When creating an index on this field the size of the database is doubled > - which makes sense. > >

[sqlite] Huge Table with only one field -- efficient way to create index ?

2009-11-26 Thread Thomas Lenders
Hello all, I am using SQLite on a mobile device. I have this one table which has only one field, but I need to search in the table very quickly. When creating an index on this field the size of the database is doubled - which makes sense. However, is there some way to implement this scenario