On 26 Nov 2009, at 2:50pm, Thomas Lenders wrote: > I am looking for an exact match as in I need to know if a number exists > in the table or not. > Something like "select count(*) from ART where artnr='0123456789'". > > I could store the data in a text file instead but then I would have to > search in the textfile on "disk", eg. a binary search algorithm or > something. > I cannot just load the textfile into memory because in this case, the > storage space on "disk" and the available memory actually come from > the same pool I would still have to store the data twice.
Okay, you have established that you should be using SQLite and yes, you do need to index that column. But you have also established that you must not define your column as a number. The following 0123456789 is not a number. The leading zero means that it must be stored as text. If you need to store such things then define your column as TEXT. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
