<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font face="Arial">Thanks Jim that did make a noticeable difference.<br>
<br>
Before tweaks<br>
Query 1 of 1, Rows read: 100, Elapsed time (seconds) - Total:
45.091, SQL query: 0.522, Building output: 44.569<br>
<br>
After tweaks<br>
Query 1 of 1, Rows read: 100, Elapsed time (seconds) - Total:
22.486, SQL query: 0.491, Building output: 21.995<br>
<br>
I must also confide that this happens to be a file with 47 columns
and as I have read the more columns returned the slower the
building of the output will be. Normally I will be selecting the
columns I need.<br>
<br>
If I run the same query selecting only four columns the result is
acceptable.<br>
Query 1 of 1, Rows read: 100, Elapsed time (seconds) - Total:
2.398, SQL query: 0.49, Building output: 1.908<br>
<br>
Thanks again Jim,<br>
<br>
Robert Rogerson<br>
<br>
</font>
<div class="moz-cite-prefix">On 2012-07-26 4:05 PM, Jim It wrote:<br>
</div>
<blockquote cite="mid:SNT...@ph...l"
type="cite">
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
<div dir="ltr">
<div dir="ltr">There are a few properties which can help.</div>
<div dir="ltr"> </div>
<div dir="ltr">iSeries Driver properties in Alias properities</div>
<div dir="ltr">Block Size = 256</div>
<div dir="ltr">Data compression = True</div>
<div dir="ltr">Extended MetaData = False</div>
<div dir="ltr"> </div>
<div dir="ltr">Global Preferences - General</div>
<div dir="ltr">Save Preferences Immediately = unchecked.</div>
<div dir="ltr"> </div>
<div dir="ltr">New Session Properities - SQL</div>
<div dir="ltr">Limit SQL History Combo Size - Smaller is faster.</div>
<div dir="ltr"> </div>
<div dir="ltr">Jim <br>
<br>
<br>
<br>
<br>
</div>
<div dir="ltr">
<hr id="stopSpelling">
Date: Wed, 25 Jul 2012 19:00:24 +0100<br>
From: <a class="moz-txt-link-abbreviated" href="mailto:rh...@hi...">rh...@hi...</a><br>
To: <a class="moz-txt-link-abbreviated" href="mailto:squ...@li...">squ...@li...</a><br>
Subject: Re: [Squirrel-sql-users] Building Output extremely
slow accessing iSeries table<br>
<br>
For what it is worth, I see exactly the same effect on iSeries
running V6R1.<br>
<br>
You get used to it.<br>
<br>
Roger
<div class="moz-cite-prefix">On 25/07/12 17:06, Robert
Rogerson wrote:<br>
</div>
<blockquote cite="mid:501...@go..."
type="cite"><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><br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/">http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/</a></pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Squirrel-sql-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Squ...@li...">Squ...@li...</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users">https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users</a>
</pre>
</blockquote>
<br>
<br>
------------------------------------------------------------------------------
Live Security Virtual Conference Exclusive live event will
cover all the ways today's security and threat landscape has
changed and how IT managers can respond. Discussions will
include endpoint security, mobile security and the latest in
malware threats.
<a class="moz-txt-link-freetext" href="http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/">http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/</a><br>
_______________________________________________
Squirrel-sql-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Squ...@li...">Squ...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users">https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users</a></div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. <a class="moz-txt-link-freetext" href="http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/">http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/</a></pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Squirrel-sql-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Squ...@li...">Squ...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users">https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users</a>
</pre>
</blockquote>
<br>
</body>
</html>
|