>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. INT should still be a bit smaller than TEXT for your purposes, because it will drop the zeros (e.g. string "100" is smaller in memory than "00000000100" even 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 > 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 for that > data. I would use TEXT. My feeling is that the data is not > so much a number as it is an incoming stream of characters > from an IO device. So, I suspect code built around a TEXT > column will ultimately be more rational looking. For > example, you won't have to pad periodically pad your data > with zeros, there won't be any signed-vs.-unsigned > confusion, etc. > > The one drawback is that an INT implementation may be more > optimal than a TEXT implementation. The string "65535" takes > up at least 5 bytes, for example, whereas the number 65535 > (base 10) will fit in two bytes. > ________________________________________ > From: sqlite-users-boun...@sqlite.org > [sqlite-users-boun...@sqlite.org] > On Behalf Of Simon Davies [simon.james.dav...@googlemail.com] > Sent: Wednesday, September 02, 2009 9:05 AM > To: General Discussion of SQLite Database > Subject: Re: [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. 2147483647 it accepts as a valid value, > 2147483648 it > rejects, saying that it is not a valid integer. > > > > > thanks > > > > Regards, > Simon > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > The information contained in this e-mail is privileged and > confidential information intended only for the use of the > individual or entity named. If you are not the > intended recipient, or the employee or agent responsible for > delivering this message to the intended recipient, you are > hereby notified that any disclosure, dissemination, > distribution, or copying of this communication is strictly > prohibited. If you have received this e-mail in error, > please immediately notify the sender and delete any copies > from your system. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > Yahoo! Cocina Encontra las mejores recetas con Yahoo! Cocina. http://ar.mujer.yahoo.com/cocina/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users The information contained in this e-mail is privileged and confidential information intended only for the use of the individual or entity named. If you are not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender and delete any copies from your system. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
