File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
REST with Spring (video course)
this week in the
JDBC and Relational Databases
How to make a query faster.
Joined: Feb 25, 2004
Mar 03, 2004 14:29:00
I have a sql query which works well. but the only problem with it
is its extremely slow.Its a compound query and i have to query DB2
database.I am using Java/JDBC to write a stored procedure
Joined: Oct 14, 2001
Mar 03, 2004 15:29:00
You need to identify the bottleneck: is it
or DB2? Run the query from a command-line tool (i.e. not through JDBC). Is it still as slow?
author & internet detective
Joined: May 26, 2003
Mar 03, 2004 18:08:00
Did you try adding indexes to your table? Also, try posting the query. Maybe someone here can give you tips on it.
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
It is sorta covered in the
JavaRanch Style Guide
subject: How to make a query faster.
JDBC QueryTimeout and Databases
Refresh a relationship
Comparable interface problem
Winners: Google Web Toolkit Applications (updated)
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015