atribute to add multiple other products

[jacopo3001]

Hi all.
I have serious doubt with the entire attributes system.

in my shop, each product has about 25 attributes. Some of them have up to 30 options (i am not creazy, i am selling prescription lenses!)

Now, because the system the way it is now make me save EACH option for EACH attributes for EACH product, my attributes table has about 260 options for each product. the DB is already about to blow.

Now, my problem is not much about the admin panel, for how to add options to a product or not. But really about the DB.
Isnt it there anyway to make this information cleaner and lighter?

according to my understanding of the problem, i should build a template of attributues(and related options) then apply it to the selected articles.
so i shouldnt have a product_to_attributesOptions any more, but a product_to_template only.

when i display product_info.php i should load all the information related to the product + all the attributes in the linked template. thats it.

I am wrong? am i missing any important information in my logic?

please advice on this. Please let me know if any one has worked on this before.
thanks

[Ajeh]

jacopo3001 ... let's stick to 1 thread on this ...
http://www.zen-cart.com/forum/showthread.php?t=59894