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 reasonable, but I think Sqlite stores everything as textual data > anyway. I think the implication is that this data will take at least > one-byte-per-digit.
Not true in SQLite 3. See: http://www.sqlite.org/datatype3.html Gerry _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
