I'm using ACS Version TestFix_1.1.8.7 Build 1170.
When I run an ACS SQL, no matter whether the results are in the same panel or a separate window, when I go to save those results to a LAN folder, whether
I'm remote connected via VPN or in the office, it is incredibly fast. Some of my SQL's are simple select * from lib.file and others are multi-file joins. No matter the case, the results
returned are very fast. Saving those results whether it is as a .pdf or .txt to a LAN folder - it is F.A.S.T. Even saving results to an open Excel SS is fast.
When saving to the LAN, I can quickly select where, what I want to name the result set, what type it will be. Never a delay.
Very Respectfully,
Michael Mayer
IBM i on Power System Admin.
IT Operations.
The Florida Bar
Tallahassee, Florida 32399-2300
mmayer@xxxxxxxxxxxxxx
https://www.floridabar.org
Office: 850.561.5761
Cell: 518.641.8906
1. RE: ACS RSS Save results takes forever when results in
separate window (Tyler, Matt)
----------------------------------------------------------------------
message: 1
date: Thu, 5 Aug 2021 16:10:24 +0000
from: "Tyler, Matt" <matt.tyler@xxxxxxxxxxxxxx>
subject: RE: ACS RSS Save results takes forever when results in
separate window
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
---------------------------------------------------------------------------------------------------------------------------------------
________________________________
Please note: Florida has very broad public records laws. Many written communications to or from The Florida Bar regarding Bar business may be considered public records, which must be made available to anyone upon request. Your e-mail communications may therefore be subject to public disclosure.
midrange.com
