Hi all, i want to store an unfixed number of object-characteristics of an unfixed datatype for 1-8000 objects. Data is mostly read, rarely written. Is there an quite optimal table-structure for that?
If i use one table for all characteristics i need as many columns as there are datatypes used. Only one column of those will be filled for each row. A lot of wasted space:( Casting the values to a fixed datatype will give the easiest structure at a high cost of performance:( Another way was to have one table for each datatype a characteristic may have. Then i will need almost one other table just for finding the table a value is stored in:( Are there any real solutions? Which would you prefer? TIA, TomH -- PROSOFT EDV-Lösungen GmbH & Co. KG phone: +49 941 / 78 88 7 - 121 Ladehofstraße 28, D-93049 Regensburg cellphone: +49 174 / 41 94 97 0 Geschäftsführer: Axel-Wilhelm Wegmann [EMAIL PROTECTED] AG Regensburg HRA 6608 USt.183/68311 http://www.proSoft-Edv.de -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
