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

Vern.
These are the paths I talked about before.

Edit > Preferences > Results > Open new results in a separate window

and

View > Output and Messages > Separate window


I did a test and the save results pop up window came up in my normal time
when in a separate window.


Kerwin

On Thu, Aug 5, 2021 at 12:00 PM Tyler, Matt <matt.tyler@xxxxxxxxxxxxxx>
wrote:

I was referring to the results windows as that was the main focus of your
thread. I have seen times when the save of the results took a long time
but never the open of the save dialog box.

-Matt


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Vern Hamberg
Sent: Thursday, August 5, 2021 10:46 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: 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/listin
f
o/midrange-l__;!!O6xM9Yim9Yk!sgQxNRVMBJ0TZaPhJinovCeAjkUTSsGgtvm3AALN
d 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__;!!O6xM9Yim9
Y
k!sgQxNRVMBJ0TZaPhJinovCeAjkUTSsGgtvm3AALNd1RlEzdkmqGOdc68DufsXA9HuzV
2
$

--
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!vn5ayoNbR6C3wrAsXuf16xw-_okxo_8PZmsZM0PL3
VjUFZn5R7jF-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__;!!O6xM9Yim9Y
k!vn5ayoNbR6C3wrAsXuf16xw-_okxo_8PZmsZM0PL3VjUFZn5R7jF-pl_iACRKNOpKwNR
$

--
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!sWwpXDjcTk81E_Om-Y_xXX6bfMtbRErDA4RLks9rRd6DHVGq4FGUg8OCbPRV_G5X0VD6$
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!sWwpXDjcTk81E_Om-Y_xXX6bfMtbRErDA4RLks9rRd6DHVGq4FGUg8OCbPRV_D0z3iEm$
.

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!sWwpXDjcTk81E_Om-Y_xXX6bfMtbRErDA4RLks9rRd6DHVGq4FGUg8OCbPRV_Kdhw_HS$
--
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://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com