Hi Richard, I totally agree with you that you want to keep the processing as close as possible to the data source. The performance limiter between the database and the application is of course the network or the TCP stack if you are hosting the database on the same server. The less data you can transfer through this bottleneck the better for the performance of your application. But like you say, each application has its own set of variables and pressures that put the architecture in one direction or another. In our particular case our data model is essentially a tree of objects that can have virtually any number of levels. Together with that there are multiple additional relationships between objects. Then of course is does not help that our users can script their own report templates :-)
Cheers, Bruce -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
