Linked by Eugenia Loli on Fri 28th Jul 2006 18:28 UTC
Permalink for comment 147612
To read all comments associated with this story, please click here.
To read all comments associated with this story, please click here.
News
Linked by Thom Holwerda on 05/22/13 13:38 UTC
Linked by Thom Holwerda on 05/22/13 13:30 UTC, submitted by JRepin
Linked by Thom Holwerda on 05/21/13 22:06 UTC
Linked by Thom Holwerda on 05/21/13 21:45 UTC
Linked by Thom Holwerda on 05/21/13 15:53 UTC
Linked by Thom Holwerda on 05/20/13 22:43 UTC
Linked by Thom Holwerda on 05/20/13 21:50 UTC
Linked by Thom Holwerda on 05/19/13 23:15 UTC
Linked by Thom Holwerda on 05/19/13 23:11 UTC, submitted by Drumhellar
Linked by Thom Holwerda on 05/18/13 21:06 UTC
More News »
Sponsored Links



Member since:
2006-04-23
I'm not sure that's a valid comparison. The application I spoke of was *quite* large and had several very complicated features requiring some very gnarly SQL to perform. One might say there was a design problem but as w/ all RDBMS-based solutions - you can't constantly change your data-model to adapt to every use-case as the system grows and changes in use.
Eventually we moved some of the features that turned out to be *mostly* read-only and that had very large queries to Crystal Reports, leaving the editing features in place. The performance increased considerably on those features. At the warehouse there were several PocketPC based applications used to scan and track inventory - as the folks at the warehouse got busier and busier, the system dragged on even further...making the web users suffer even more.
I'm not sure you can compare the portal solution you mention w/ the application we dealt with - I'd dare say the complexity level was many times more in comparison.
Aside from performance problems, a system based on copious amounts of ADO.NET data-access code, stored procedures, and ASP.NET turned out to be highly resistent to change. It was not fun to change & maintain as it grew. However, these problems went away as we moved to an EJB3-based solution w/ JPA. It performs and changes can be made many times easier.