Re: [sqlite] Integer Storage class

On 2 Sep 2009, at 3:26pm, Sebastian Bermudez wrote: > i chose Integer for Performance isues... i'm develop. an POS > Software and our articles table has lot's of records. i need to > optimize search. an Integer (1,2,4,6,8 bytes) is faster that 13- > bytes-ean text for

Re: [sqlite] Integer Storage class

Beau Wilkinson wrote: >> i chose Integer for Performance isues... i'm develop. an POS Software >> and our articles table has lot's of >records. i need to optimize >> search. an Integer (1,2,4,6,8 bytes) is faster that 13-bytes-ean text >> for >comparison. >> > > That's

Re: [sqlite] Integer Storage class

On Wed, Sep 02, 2009 at 10:47:53AM -0500, Beau Wilkinson scratched on the wall: > That's reasonable, but I think Sqlite stores everything as textual > data anyway. SQLite2 did store everything as text strings, but SQLite3 does not. See "Storage Classes": http://sqlite.org/datatype3.html

Re: [sqlite] Integer Storage class

n though both are still larger than the integer 100). But if INT simply doesn't have the necessary range, your options are limited. --- El mié 2-sep-09, Beau Wilkinson <b...@mtllc.us> escribió: > De: Beau Wilkinson <b...@mtllc.us> > Asunto: Re: [sqlite] Integer Storage class &g

Re: [sqlite] Integer Storage class

cribió: > De: Beau Wilkinson <b...@mtllc.us> > Asunto: Re: [sqlite] Integer Storage class > Para: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Fecha: miércoles, 2 de septiembre de 2009, 11:14 am > I probably wouldn't use INT fo

Re: [sqlite] Integer Storage class

e: [sqlite] Integer Storage class 2009/9/2 Sebastian Bermudez <sebastian.bermu...@yahoo.com>: > Ok. my problem is my SQLITE front end (SQLITE ADMINISTRATOR v 0.8.3.2) ... > show me 0 (cero) in that column. Looks like SQLITE ADMINISTRATOR v 0.8.3.2 only deals with signed 32 bit values.

Re: [sqlite] Integer Storage class

2009/9/2 Sebastian Bermudez : > Ok. my problem is my SQLITE front end (SQLITE ADMINISTRATOR v 0.8.3.2) ... > show me 0 (cero) in that column. Looks like SQLITE ADMINISTRATOR v 0.8.3.2 only deals with signed 32 bit values. 2147483647 it accepts as a valid value,

Re: [sqlite] Integer Storage class

Ok. my problem is my SQLITE front end (SQLITE ADMINISTRATOR v 0.8.3.2) ... show me 0 (cero) in that column. thanks --- El mié 2-sep-09, Simon Davies <simon.james.dav...@googlemail.com> escribió: > De: Simon Davies <simon.james.dav...@googlemail.com> > Asunto: Re: [sqlite] Int

Re: [sqlite] Integer Storage class

2009/9/2 Sebastian Bermudez : > hi! i have an table ( articles ) with a column for EAN13 Barcodes like ( > 7790080066784). > I have created the column with Integer data type... ( i have chose that data > type after read the SQLITE DOC where it' say: "INTEGER. The

[sqlite] Integer Storage class

hi! i have an table ( articles ) with a column for EAN13 Barcodes like ( 7790080066784). I have created the column with Integer data type... ( i have chose that data type after read the SQLITE DOC where it' say: "INTEGER. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes