Krzysztof, Take a look at some PHP Profiling extensions, such as Advanced PHP Debugger or XDebug. This will help you locate the slow parts of your script.
"Krzysztof Gorzelak" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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