A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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?
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.
How To Ask Questions The Smart Way
Blogging on Certs:
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-2014