Page 2 of 2

Posted: Wed Jul 14, 2004 4:11 pm
by EricS
I have tried building object trees with multiple queries and it does make coding much easier, but you pay for it dearly in scalability. As soon as your traffic or database size gets large, the site grinds to a halt.

I now use Data Access Objects to build multiple objects from single queries. There is more code and more design time required to program in this fashion, but the page speed in much faster.