Good program design would have the SQL appear only in one place. -ted
Rog�rio Saran wrote:
> If you are really concerned with application manageability, stuck with
> stored procedures.
>
> Consider a sudden need to change database structure, the DBMS version or
> even switch the whole DBMS package for a higher performance product.
>
> It will be light-years easier to rewrite procedures than to look for
> scattered sql sentences all over your pages.
>
> Ritu Kamboj wrote:
> >
> > Hi all,
> >
> > I have a query regarding Stored procedure,Although i know this site is
> > specificallyfor jsp only,
> > plese excuse for this...
> > My question is Is It wiseable to use Stored Procedures in the program
> > instead of using SQL query??
> > B'coj i tried with both but, i found stored procdures are taking mauch of
> > time as comparing
> > to SQL Queries.Although i heard stored are very efficient .
> > If anybody can throw light on this .I'll be thankful
> > thanks
> > regards
> > ritu
> >
> > _____________________________________________________________
> >
> > Visit http://www.PalmGreetings.com The Most Happening and
> > The first & only Mobile greeting site.
> > * Send & Receive e-cards using your Hand held/Palm top/WAP Phone
> > * Pleasure viewing animated cards on your device
> > * Unleash your creativity by creating your own cards
> >
> > ===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
