All, One of the tables in my database has 4 columns that will hold small (under 5K) BLOBs. In many cases there will be no data at all in one or more of these columns (see sample below). Does this present any kind of problem? Should I split this table up into smaller tables to eliminate the NULLs (e.g. use one table each for IL, Phase, RL, Isolation)? I'm not sure what the best design choice would be.
Here is a sample of what the data will look like: GUID Path IL Phase RL Isolation 9a778c0e 1 BLOB BLOB BLOB NULL 9a778c0e 2 BLOB BLOB BLOB NULL 9a778c0e 3 BLOB BLOB BLOB NULL 9a778c0e 4 BLOB BLOB BLOB NULL 9a778c0e 5 NULL NULL BLOB NULL 9a778c0e 6 BLOB BLOB BLOB NULL 9a778c0e 7 BLOB BLOB BLOB NULL 9a778c0e 8 BLOB BLOB BLOB NULL 9a778c0e 9 BLOB BLOB BLOB NULL 9a778c0e 10 NULL NULL NULL BLOB 9a778c0e 11 NULL NULL NULL BLOB 9a778c0e 12 NULL NULL NULL BLOB 9a778c0e 13 NULL NULL NULL BLOB 9a778c0e 14 NULL NULL NULL BLOB 9a778c0e 15 NULL NULL NULL BLOB 9a778c0e 16 NULL NULL NULL BLOB 9a778c0e 17 NULL NULL NULL BLOB 9a778c0e 18 NULL NULL NULL BLOB 9a778c0e 19 NULL NULL NULL BLOB 23239d6b 1 BLOB BLOB BLOB NULL 23239d6b 2 BLOB BLOB BLOB NULL 23239d6b 3 BLOB BLOB BLOB NULL 23239d6b 4 BLOB BLOB BLOB NULL 23239d6b 5 NULL NULL BLOB NULL 23239d6b 6 BLOB BLOB BLOB NULL 23239d6b 7 BLOB BLOB BLOB NULL 23239d6b 8 BLOB BLOB BLOB NULL 23239d6b 9 BLOB BLOB BLOB NULL 23239d6b 10 NULL NULL NULL BLOB 23239d6b 11 NULL NULL NULL BLOB 23239d6b 12 NULL NULL NULL BLOB 23239d6b 13 NULL NULL NULL BLOB 23239d6b 14 NULL NULL NULL BLOB 23239d6b 15 NULL NULL NULL BLOB 23239d6b 16 NULL NULL NULL BLOB 23239d6b 17 NULL NULL NULL BLOB 23239d6b 18 NULL NULL NULL BLOB 23239d6b 19 NULL NULL NULL BLOB Thanks for your help... -- Bill Drago Senior Engineer L3 Communications / Narda Microwave East 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / william.dr...@l-3com.com CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
