[Squirrel-sql-users] Building Output extremely slow accessing iSeries table
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
Menu
▾
▴
[Squirrel-sql-users] Building Output extremely slow accessing iSeries table
|
From: Robert R. <rog...@gm...> - 2012-07-25 16:06:24
|
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font face="Arial">Hi all,<br>
<br>
I have checked the documentation and googled for a solution/advise
but not found any.<br>
<br>
I have just started using Squirrel 3.3.0 with the intention of
replacing iNavigator's Run SQL Scripts. I am accessing DB2 on an
iSeries at V7.1<br>
<br>
The biggest problem I have experienced is it takes over 30 seconds
to return a query. <br>
<br>
The status bar tells me<br>
"Query 1 of 1, Rows read: 100, Elapsed time (seconds) - Total:
45.186, SQL query: 0.577, Building output: 44.609"<br>
<br>
The the query is a simple SELECT * FROM mytable. I have read that
the number of columns returned slows down execution. <br>
<br>
What I'd like to know is there a way of limiting the Building
Output step. One thought was to only return the Results tab not
the MetaData, Info and Overview tabs, but I have been unable to
find how to turn these off.<br>
<br>
Any help would be appreciated. I am impressed with this tool but
if a simple query takes over 39 to return I don't think it will be
of use top me.<br>
<br>
Thanks,<br>
<br>
Robert Rogerson<br>
</font>
</body>
</html>
|