Re: oop too slow

> > 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? > > Why are you doing 300(!!!) mysql queries? > I guess you can retrieve the same data with much less queries. > 300 queries are slow ... not OOP. > Well, I changed my script a little for tests and turned off the queries. Now I'm setting some defaults data to those 300 objects but it's still too slow. I create for every value, key and product a different object so it's in fact 30*10*5 objects. Then I run __toString() method one by one and generate my page. Is it proper to creating a separate objects for all values ? It makes my code much more easy... Krzysztof Gorzelak krzysztof@uno.pl