Hi I'm trying my new php5 script, but it takes about 1.2s to generate my page. That is, how my oop model looks like :
[category] | | | [photo] [desc] [products] [products] | [product] | | | [photo] [desc] [keys] [keys] | [key] | [values] | [value] Each object gets data from mysql by itself. The generation time of 1 category [30 products, 10 keys, 5 values ~= 300 mysql queries] takes as I said more than a 1s (on quite fast machine). How can this model be improved? Do I create too many objects ? What are the oop solutions for such problem ? I also use an extra table to create many-to-many relation betwean a product and a key. Is this the only way in mysql ? [product] | [product_id, key_id] | [key] Thanks a lot help Krzysztof Gorzelak [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php