Maryw Posted March 20, 2007 Posted March 20, 2007 I am going to have a lot of options and option values for my store. I wonder if there is anything I can do to the database to improve the preformance. Since the products' options and option values will also be stored in the products attribute table, I wonder if I can remove the products options to products option values table. I do not need to change the option names and option values once they are entered into the store. I will only use the easy populate to import each product along with its attributes information once to the store and I do not use the attribute editor in admin. In this case can I remove the products options to products option values table? And which files will be affacted and what search query modifications I will need to make? Also since my product option values table is going to be pretty large, I wonder if I can split it into smaller ones by each language. That is one product option value table holds only option values in one language. And in this case, which files need to be edited and what query modifications need to be made? Can I also split the product attributes table by product option? So for each product option there will be a separate product attributes table? Thank you.
Guest Posted March 20, 2007 Posted March 20, 2007 To improve performance you could cache the sql queries. But if you have way too many attributes you should use the option type feature module and then use an input box instead of endless drop-down lists that aren't user friendly. http://www.oscommerce.com/forums/index.php?showtopic=253763
Recommended Posts
Archived
This topic is now archived and is closed to further replies.