Thread: [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
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> |
From: Roger H. <rh...@hi...> - 2012-07-25 18:00:39
|
For what it is worth, I see exactly the same effect on iSeries running V6R1. You get used to it. Roger On 25/07/12 17:06, Robert Rogerson wrote: > Hi all, > > I have checked the documentation and googled for a solution/advise but > not found any. > > 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 > > The biggest problem I have experienced is it takes over 30 seconds to > return a query. > > The status bar tells me > "Query 1 of 1, Rows read: 100, Elapsed time (seconds) - Total: 45.186, > SQL query: 0.577, Building output: 44.609" > > The the query is a simple SELECT * FROM mytable. I have read that the > number of columns returned slows down execution. > > 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. > > 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. > > Thanks, > > Robert Rogerson > > > ------------------------------------------------------------------------------ > 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. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
From: Jim It <ji...@ho...> - 2012-07-26 20:05:50
|
There are a few properties which can help. iSeries Driver properties in Alias properities Block Size = 256 Data compression = True Extended MetaData = False Global Preferences - General Save Preferences Immediately = unchecked. New Session Properities - SQL Limit SQL History Combo Size - Smaller is faster. Jim Date: Wed, 25 Jul 2012 19:00:24 +0100 From: rh...@hi... To: squ...@li... Subject: Re: [Squirrel-sql-users] Building Output extremely slow accessing iSeries table For what it is worth, I see exactly the same effect on iSeries running V6R1. You get used to it. Roger On 25/07/12 17:06, Robert Rogerson wrote: Hi all, I have checked the documentation and googled for a solution/advise but not found any. 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 The biggest problem I have experienced is it takes over 30 seconds to return a query. The status bar tells me "Query 1 of 1, Rows read: 100, Elapsed time (seconds) - Total: 45.186, SQL query: 0.577, Building output: 44.609" The the query is a simple SELECT * FROM mytable. I have read that the number of columns returned slows down execution. 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. 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. Thanks, Robert Rogerson ------------------------------------------------------------------------------ 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. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users ------------------------------------------------------------------------------ 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. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
From: Robert R. <rog...@gm...> - 2012-07-26 20:59:31
|
<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> |