dbTalk Databases Forums  

Re: Occasional slow query

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss Re: Occasional slow query in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ollie
 
Posts: n/a

Default Re: Occasional slow query - 08-15-2003 , 06:51 PM






ak_tiredofspam (AT) yahoo (DOT) com (AK) wrote in message news:<46e627da.0308150613.707d2318 (AT) posting (DOT) google.com>...
Quote:
I'd try VALUES(1)

What's the capacity of the host machine.
- Does it have enought CPU and memory?
- Is it NT or Unix platform?


Reply With Quote
  #2  
Old   
Bill Littman
 
Posts: n/a

Default Re: Occasional slow query - 08-19-2003 , 11:20 AM






It is an NT machine and I think the CPU (dual Xeon 2 GHz) is fine. I just
reviewed memory usage (we have 1 GB) and I am pretty sure I am running into
paging issues, which might explain the delays I am seeing.

Even still, I would like to know the answer to my second question:
2. Could I be running into garbage collection issues with the JDBC code? If
so, is there any way to tune the JVM that the JDBC driver uses for garbage
collection?

Thanks,

-Bill


"Ollie" <oamd (AT) yahoo (DOT) com> wrote

Quote:
ak_tiredofspam (AT) yahoo (DOT) com (AK) wrote in message
news:<46e627da.0308150613.707d2318 (AT) posting (DOT) google.com>...
I'd try VALUES(1)


What's the capacity of the host machine.
- Does it have enought CPU and memory?
- Is it NT or Unix platform?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.