Re: Where to store SQL statement

On May 10, 4:13 pm, Lew <l...@xxxxxxxxxxxxxxxxxxxx> wrote:
Lulu58e2 wrote:
I use MySQL stored procedures: no files to maintain, optimized
execution. (Note: requires MySQL 5.0 I think).

Less scalable than business logic in the business layer. I am curious,
though, how do you rate the optimization of the execution? Have you compared
the stored procedure approach to application-server clusters with the business
logic in the middle tier under massive parallel loads?
<snip>
--
Lew

Yikes, you got me. I actually haven't rated the optimization or
compared various tier strategies. Stored procedures for me simply mean
not storing hard-coded SQL; however, the other suggestions (e.g.
java.util.PropertyResourceBundle) sound interesting in light of what
you've asked.

C>

----------------------------------------------------------------------
A reproof entereth more into a wise man than an
hundred stripes into a fool. Prov.17:10

.

Relevant Pages

  • Re: Help on choosing a valid pattern: composite or not?
    ... that's a job for another subsystem that is encapsulated by an interface that is designed for the neural net view. ... B-(The CRUD/USER layered models are designed for pipeline applications between a UI and an RDB where the "business" layer doesn't really do anything except provide data integrity validation and an intermediate step stone for converting one view to the other. ... solution (e.g., the basic net configuration/navigation, training logic, and execution logic could be quite different subject matters). ... Whenever they get to a Node, they invoke the relevant behaviorvia the "links" to the Strategy/State. ...
    (comp.object)
  • Re: middle tier recommendations
    ... Continuous business use M-S 8-7. ... During peak times we could see a sudden spike in usage. ... >> be passing custom objects back and forth with the middle tier interacting ...
    (microsoft.public.dotnet.framework)
  • Re: What am I missing?
    ... protocols regarding how it did business then a business layer is definitely ... I think what you are saying is the middle tier simplifies a complex ... One of the developers told me SOAP was the new way ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: middle tier recommendations
    ... Along the lines of what Param said -- remoting & web services would be ... your middle tier or if you have some other ... Continuous business use M-S 8-7. ...
    (microsoft.public.dotnet.framework)
  • RE: Caching Design
    ... static content that will be displayed throughout u can cache this at the UI ... level.At business level,u can cache the things which is frequently accessed ... "Jim Douglas" wrote: ... > My setup is web application, middle tier for business logic and data access. ...
    (microsoft.public.dotnet.general)