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
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
>
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
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
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
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
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.
>
>
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
8 matches
Mail list logo