Re: ACS RSS Save results takes forever when results in separate window

You mention Ctrl-S from the menu - are you talking about saving the session or saving the results?  I see that there is a Save results in the separate results window that is also Ctrl-S.

Anyhow, I tried it in the results window with a very simple SELECT (select * from qiws/qcustcdt) and the prompt was displayed immediately.

The other time, the statement was a triple JOIN of nested table expressions - but in that case, it was as I described below - with results in the main window it was almost instantaneous - with results in a separate window, it took forever.

Again, however, I tried something similar, and it was just as fast both in separate window and in the main window.

Guess I have to suspect network speed after all - thanks for the thoughts, though.

Cheers
Vern

On 8/5/2021 11:10 AM, Tyler, Matt wrote:

With CA the work around until IBM fixes it, is to qualify ALL tables/views in the query. CA works so much faster when tables are qualified. Just remember to remove the qualification if you are work on a programs query.

I doubt I was the one that mentioned any preference, at first, Kerwin mentioned a setting pattern in his thread at the end.

When I select from the Menu to save or use Ctrl+S its only within a couple seconds that the save dialog is presented. I can only see that remotely would cause it to be slower if it had to reconnect to the a remote file share. I save locally and it always to the same folder. I am an admin on my system but I save to a folder on my Windows Desktop. Does your company use remote workspaces for your desktop (I don't actually recall the proper name for it). Its where they have your user folders stored on a network folder and the link it back to your system. We had a few that had that and everything was slow for them when they accessed from their c:\users\ folder. Create a folder outside of C:\Users to save the results to and see if that improves it.

-Matt


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Vern Hamberg
Sent: Thursday, August 5, 2021 9:50 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: ACS RSS Save results takes forever when results in separate window

Hi Matt

Remotely, yes - that's why I usually can't use Content Assist. But I'm saving to the desktop.

The difference is that when I keep results in the main window, it is instant. If I have results in a separate window, it can be 5 minutes or more before the prompt is displayed.

So there is a difference somehow - were you the one who gave us the preference settings to use? There was a 2nd setting, I don't remember.

A good test would be to try saving the results when locally connected, too.

Regards
Vern

On 8/5/2021 10:14 AM, Tyler, Matt wrote:

Are you working remotely and saving to a file share?

Most of the open dialogs that connect to file share locations do take longer when remote and not local my laptop.

-Matt


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Vern Hamberg
Sent: Thursday, August 5, 2021 9:09 AM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: ACS RSS Save results takes forever when results in separate
window

Hi all

There was a recent thread about showing ACS RSS results in a separate window. Also about cursors closed after a set time, which is fantastic.

So I tried the separate windows thing - I'm using 1.1.8.7 - if I select to save results in that windows, it can take several minutes before the prompt for file type and location is displayed.

If I have the results in the main window, that dialog is displayed immediately.

Has anyone else had this happen, or can try it out. I will eventually see if I can submit a ticket, it's not easy here, due to some authority setups.

Cheers
Vern
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
https://urldefense.com/v3/__https://lists.midrange.com/mailman/listinf
o/midrange-l__;!!O6xM9Yim9Yk!sgQxNRVMBJ0TZaPhJinovCeAjkUTSsGgtvm3AALNd
1RlEzdkmqGOdc68DufsXGwUZjhQ$ or email:
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.com/v3/__https://archive.midrange.com/midrange-l__;!!O6xM9Yim9Yk!sgQxNRVMBJ0TZaPhJinovCeAjkUTSsGgtvm3AALNd1RlEzdkmqGOdc68DufsXDX3KbNi$ .

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.com/v3/__https://amazon.midrange.com__;!!O6xM9Yim9Y
k!sgQxNRVMBJ0TZaPhJinovCeAjkUTSsGgtvm3AALNd1RlEzdkmqGOdc68DufsXA9HuzV2
$

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://urldefense.com/v3/__https://lists.midrange.com/mailman/listinfo/midrange-l__;!!O6xM9Yim9Yk!vn5ayoNbR6C3wrAsXuf16xw-_okxo_8PZmsZM0PL3VjUFZn5R7jF-pl_iACRKD5jdlpv$
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.com/v3/__https://archive.midrange.com/midrange-l__;!!O6xM9Yim9Yk!vn5ayoNbR6C3wrAsXuf16xw-_okxo_8PZmsZM0PL3VjUFZn5R7jF-pl_iACRKMTiOAw7$ .

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://urldefense.com/v3/__https://amazon.midrange.com__;!!O6xM9Yim9Yk!vn5ayoNbR6C3wrAsXuf16xw-_okxo_8PZmsZM0PL3VjUFZn5R7jF-pl_iACRKNOpKwNR$