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
