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.
--- El mié 2-sep-09, Beau Wilkinson <[email protected]> escribió: > De: Beau Wilkinson <[email protected]> > Asunto: Re: [sqlite] Integer Storage class > Para: "General Discussion of SQLite Database" <[email protected]> > 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: [email protected] > [[email protected]] > On Behalf Of Simon Davies [[email protected]] > 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 <[email protected]>: > > 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 > [email protected] > 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 > [email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
