Am Sonntag, 12. Januar 2003 05:33 schrieb arun s: > hi all, > Im using JSP and DB2.
Now..what should I recommend upon this? Using Oracle instead of DB2? Well, if that would help... > My program is running very slow . Check what exactly *is* slow. If JSP alone were slow, you probably wouldn't even notice. But database queries might take quite a lot of time if coded sub-optimal. It all depends on the concrete app you're developing. From an abstract view, neither JSP nor DB2 are slow. Either your task is very complex, or you're making a mistake somewhere. But where, I just can't tell from the infor- mation given. > How can I make it faster. Is there some thing to make programs faster. JSPs are translated into Servlets and then executed as Java code, and on the server, Java is comparatively fast. I really doubt this is the bottleneck, as we're talking about the millisecond range here. Still, a single mis-programmed query can easily take 10 seconds or more to complete, depending on the database size and the effectiveness of the query itself. Look there first, I'd say, but as I don't know anything about your app, I can't say more on your problem. Optimizing the Java side probably wouldn't be the key, still. > If so plz reply me at the earliest. > Thanx in advance > karthik HTH, -- Chris (SCPJ2) ==========================================================================To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com