[IQUG] Slow fetching between two identical IQ servers

Kutlu, Mustafa mustafa.kutlu at sap.com
Thu Nov 16 06:43:54 MST 2017


You should be able to change these option from Interactive SQL directly.
On the top menu of Interactive SQL, choose options and set them off.

From: iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] On Behalf Of Louie, David
Sent: Thursday, November 16, 2017 4:17 PM
To: IQ Users Group <iqug at iqug.org>
Subject: [IQUG] Slow fetching between two identical IQ servers

[cid:image002.jpg at 01D35EFA.1629A7E0]


It takes 16X longer to fetch data from IQ to a flat file in our QA server vs our DEV server.

Hardware same, nic card, same, RAM and CPU same.  Table is the same.

My packet size is 16000 ( max).

However I see that these two isql configs are set in the slower server.

Suspecting this may be the issue I want to turn them off or rest to default however cannot


QTREWD_QA_IQ.dlouie..2010.1> set option public.ISQL_SHOW_MULTIPLE_RESULT_SETS='OFF'
QTREWD_QA_IQ.dlouie..2010.2> go
SQL Anywhere Warning 120: 'ISQL_SHOW_MULTIPLE_RESULT_SETS' is an unknown option


QTREWD_QA_IQ.dlouie..2012.1> set option public.ISQL_PRINT_RESULT_SET='LAST';
SQL Anywhere Warning 120: 'ISQL_PRINT_RESULT_SET' is an unknown option
QTREWD_QA_IQ.dlouie..2013.1>

This is IQ 15.4.

Thanks
David



This message may contain information that is confidential or privileged. If you are not the intended recipient, please advise the sender immediately and delete this message. See http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers for further information.  Please refer to http://www.blackrock.com/corporate/en-us/compliance/privacy-policy for more information about BlackRock’s Privacy Policy.
For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/en-us/about-us/contacts-locations.

© 2017 BlackRock, Inc. All rights reserved.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20171116/49cbc5ab/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 13395 bytes
Desc: image002.jpg
URL: <http://iqug.org/pipermail/iqug/attachments/20171116/49cbc5ab/attachment-0001.jpg>


More information about the IQUG mailing list