Hello! I have over 100 columns in a table. Most of the columns will stay empty. Just an example:
customer_lastname customer_firstname customer_street customer_PhonePrivate (will almost always stay empty) customer_PhoneCompany customer_PhoneMobile customer_PhoneWAP (will almost always stay empty) customer_Phone1 (will almost always stay empty) customer_Phone2 (will almost always stay empty) Because I felt so stupid about these mostly empty columns taking so much space, I tended to replace all the "phone" columns by a single column named "customerPhone". I stored the values into customerPhone like that: <cpp=><cpc=><cpm=93829343><cpw=><cp1=234928734><cp2=> This is kind of an xml design, but it works and it takes up less space. I "decompile" this weird expression at runtime to get the separate values again. Can I get an opinion on it? I have not found any good information on the number of columns and relationship between their count and speed and diskspace used. Thank you very much! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
