PDA

View Full Version : choices regarding where to place code - in the database or middle tier


JEDIDIAH
06-24-2004, 12:58 PM
["Followup-To:" header set to comp.database.oracle.]
On 2004-01-20, Daniel Morgan <damorgan@x.washington.edu> wrote: Joe Weinstein wrote: However, that dbms-specific level should be as narrow and controllable/switchable as possible. J2EE standards help there. Joe Just my 2 cents Daniel I appreciate your opinion and your honesty that your perspective comes from selling that middle tier but I completely disagree. The 'lets push more bytes down the pipe and across all those routers' thinking is not going to lead to performance. You may be scalable but performance will suffer. And you will be no more scalable than a thinner client. Render under to database everything you can do in the database and let the middle tier do what it does best ... fail-over, load levelling, and serving up the front-end.

You are painting with far too broad a brush. Some of your examples below
represent absurd examples of middle-tier database processing. They would
(and do) horrify anti-centrists as much as they do you. Some of them
demonstrate that even good ideas can be poorly implemented.
Try tuning all that rotten SQL coming from those fat front-ends sometime and you will understand why those here that have experience with PeopleSoft, SAP, Baan, and Siebel are remarkably unhappy.


--
The public has a right to free music. It's part of the bargain that
was originally made with musicians and publishers. It's time that the |||
debate was shifted to reflect that. Robber Barons and their Toadies / | \
are distracting us from the original facts of the situation.


MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service