troubleshooting Question

JDBC Query too slow

Avatar of gaugeta
gaugeta asked on
DatabasesSybase DatabaseJSPSQL
20 Comments1 Solution693 ViewsLast Modified:
Hi experts...
I have a set of jdbc queries to select,update and insert which i have written in a common class and imported the class to every jsp page in my project.
The queries are woking fine but are extremely slow.One of the pages just takes 25 to 30 seconds to load where data is just selected from the database.
There are ofcourse thousands of records to access but how do i improve the speed of the sql operations.
Please help.
ASKER CERTIFIED SOLUTION
Tomas Helgi Johannsson
Database Administrator / Software Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 20 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 20 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros