Re: PowerLink & folder redirection

Tom E Stieger <TEStieger-7y5+ka1ulstWk0Htik3J/[email protected]>
Newsgroups gmane.comp.systems.as400.mapics
Message-ID <[email protected]>
Yes.  Go to Help -> About Infor XA
Click Ctrl + D
Select SQL Monitor.

Then run your workbench and you'll get all the SQL Statements.

Also, you can run the database connection monitor in debug mode to see any advise indexes to help speed things along.

-Tom Stieger
Engineer
California Fine Wire
testieger-7y5+ka1ulstWk0Htik3J/[email protected]

-----Original Message-----
From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of ibm
Sent: Wednesday, October 28, 2009 12:47 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] PowerLink & folder redirection

Looks like it's one of our custom cards slowing it down.  Is there a way to capture the SQL query of a card?

-----Original Message-----
From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
[mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Kevin Fox
Sent: Wednesday, October 28, 2009 2:06 PM
To: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] PowerLink & folder redirection

If you add the time of each the individual queries up, is it more or less than the time of the workbench to refresh all three screens from a single change to the broadcaster?

-----Original Message-----
From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
[mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]]
On Behalf Of ibm
Sent: Wednesday, October 28, 2009 11:44 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] PowerLink & folder redirection

The slowdown is inside a workbench, quering a customer order.  There are
3 screens: CO Hold, Customer Order and CO Holds.  The last one is the Broadcaster.  Powerlink performs fine when each screen is accessed individually.

Any ideas?

-----Original Message-----
From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
[mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Kevin Fox
Sent: Tuesday, October 27, 2009 11:03 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] PowerLink & folder redirection

It is possible if there is alot of new object definitions.  I'm assuming this is because of the new link manager which really is dong more including connecting via system.link to the new EBS.

-----Original Message-----
>From: Weston Wheat <[email protected]>
>Sent: Oct 27, 2009 8:10 AM
>To: MAPICS ERP System Discussion <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]>
>Subject: Re: [MAPICS-L] PowerLink & folder redirection
>
>I been finding that the new 7.8 PowerLink is quite a bit slower than
the
>7.6 PowerLink.
>Weston
>
>-----Original Message-----
>From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
>[mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of ibm
>Sent: Tuesday, October 27, 2009 6:37 AM
>To: MAPICS ERP System Discussion
>Subject: Re: [MAPICS-L] PowerLink & folder redirection
>
>Thanks.  Is this process documented by Infor somewhere?
>
>-----Original Message-----
>From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
>[mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Kevin Fox
>Sent: Monday, October 26, 2009 5:48 PM
>To: 'MAPICS ERP System Discussion'
>Subject: Re: [MAPICS-L] PowerLink & folder redirection
>
>When PowerLink launches it checks several items to enshure that it is
up
>to
>date:
>
>1. client release level.  If Link Manager has been directed to update a 
>new release level of the client code, the system will download the new 
>code and replace the older version during the login session.  If the 
>new client code contains many new code files and or fixed code, etc. 
>,the update can take awhile which is variable depending upon the amount 
>of code that is refreshed.
>
>2. User definitions.  All user definitions are searched to ensure that 
>they are copied to the client which will enable access.  A partial list 
>includes, views, subsets, sorts, templates....
>
>3. Object definitions need to be refreshed if changed from integrator.
>This
>includes customized objects and system links.
>
>I'm sure there are more.
>
>The real test is what happens AFTER the login.  What is the speed like?
>If
>the speed after login is acceptable, then you will want to check for 
>customization of the user definitions and/or object definitions.
>
>Kevin
>
>-----Original Message-----
>From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
>[mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]]
>On Behalf Of ibm
>Sent: Friday, October 23, 2009 1:24 PM
>To: MAPICS ERP System Discussion
>Subject: Re: [MAPICS-L] PowerLink & folder redirection
>
>I will look through the archives.  
>
>About 5 minutes when it used to be 15 seconds.  There are couple custom 
>definitions but it's a few kilobytes here and there...
>
>Can you give more detail on this "refreshing on login" process?
>
>-----Original Message-----
>From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
>[mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Kevin D Fox
>Sent: Friday, October 23, 2009 3:24 PM
>To: MAPICS ERP System Discussion
>Subject: Re: [MAPICS-L] PowerLink & folder redirection
>
>What is "a long time"?  Remember that the code is refreshing on log in 
>and therefore depending on systems and network time can very.  My
system
>is a very fast system and takes from 30 seconds to 5 min depending on 
>the amount of code and user definitions that need to be refreshed and / 
>or loaded.
>
>We have had many detailed discussions on this topic.  Please read the 
>archives.
>
>------Original Message------
>From: ibm
>Sender: Ximena Rodriguez
>To: MAPICS ERP System Discussion
>ReplyTo: MAPICS ERP System Discussion
>Subject: [MAPICS-L] PowerLink & folder redirection
>Sent: Oct 23, 2009 12:53 PM
>
>My PowerLink is taking a long time to start up.  Could this be related 
>to the fact that my 'c:\documents and settings' is redirected ?
>
> 
>
>R7 (jre 1.4.2)
>
> 
>
>Thanks
>
>_______________________________________________
>This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To 
>post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, 
>or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/mapics-l
>or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a 
>moment to review the archives at http://archive.midrange.com/mapics-l.
>
>
>
>Sent from my Verizon Wireless BlackBerry 
>_______________________________________________
>This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To 
>post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, 
>or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/mapics-l
>or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a 
>moment to review the archives at http://archive.midrange.com/mapics-l.
>
>_______________________________________________
>This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To 
>post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, 
>or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/mapics-l
>or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a 
>moment to review the archives at http://archive.midrange.com/mapics-l.
>
>
>_______________________________________________
>This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To 
>post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, 
>or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/mapics-l
>or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a 
>moment to review the archives at http://archive.midrange.com/mapics-l.
>
>_______________________________________________
>This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To 
>post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, 
>or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/mapics-l
>or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a 
>moment to review the archives at http://archive.midrange.com/mapics-l.
>
>_______________________________________________
>This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To 
>post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, 
>or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/mapics-l
>or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a 
>moment to review the archives at http://archive.midrange.com/mapics-l.
>


Kevin Fox
(909) 762-1384 mobile
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.


_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.



_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.