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 comparison.
Do you really need that performance ? Are you comparing thousands of records every minute ? Because handing those codes as if they're integers is going to cause problems in the future. If you really need the extra speed you're getting it might be worth it, but if you're making things fast just because you know how, you're probably better off handling that column as if it's strings, not integers. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
