Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Monday, January 20, 2020 
 
slxdeveloper.com Community Forums  
   
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
 External Development Forums - Design & Architecture Topics
Forum to discuss designing applications to work with SalesLogix. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to Design & Architecture Topics | New ThreadView:  Search:  
 Author  Thread: SLX performance
Snow Monkey
Posts: 214
 
SLX performance Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 13 Oct 09 4:43 PM
When i switch over to the Notes-Histopry Tab in slx , for this orgs with many Notes , it is very slow. THis is the query getting executed. I looked at the exec plan in sql and everything seems to be in order with only one Table scan against picklist table(which i created an index)

on sql server its gets executed in 0.1 secs and it is taking ~15 secs to show up in slx client. Our App server sits across a WAN and that is what i thought the reason woudl be. Recently i created a Remote office and checked that in that RO server and the same thing(maybe ~12 secs now). Why is this huge delay. There were no clusteered indexes in the table and i created one with the ID.

Anyone have any ideas?

SELECT A1.HISTORYID, A1.ATTACHMENT, A2.TEXT A2_TEXT, A1.COMPLETEDDATE, A1.USERID, A1.CONTACTNAME, A1.RESULT,
A1.DESCRIPTION, A3.LONGCATEGORY A3_LONGCATEGORY,A3.HISTORYID,A2.ITEMID
FROM HISTORY A1 INNER JOIN PICKLIST A2 ON (A1.TYPE=A2.ID)
LEFT OUTER JOIN AAM_HISTORY_EXT A3 ON (A1.HISTORYID=A3.HISTORYID)
WHERE ((A1.TYPE<>262162) OR (A1.USERID='U6UJ9A00004D')) AND (A1.ACCOUNTID = 'A6UJ9A0013KQ')
AND (A1.TYPE <> 262156) Order By A1.COMPLETEDDATE Desc
[Reply][Quote]
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
 
Re: SLX performance Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 13 Oct 09 5:41 PM
Have you looked into the query using the the SLX Profiler?

The SLX Profiler will give you several additional details:
- Parse time
- Prepare time
- Secure Time
- Execute Time
- Get Rows Time
- Log time



The query may indeed get executing on under a second on the SQL server, but how long does it take for the data to reach the client? (Network Latency)?
By using the SLX Profiler, you will get the stats for the execution as they are gather on the client side, it may help you identify where your bottleneck lies.
[Reply][Quote]
Mike Spragg
Posts: 1226
Top 10 forum poster: 1226 posts
 
Re: SLX performance Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Oct 09 4:43 AM
What version of SLX - the Notes-History/Attachment tabs are notorious for running the query without an ID (brings back everything!) and multiple times - check here for solution: http://www.empath-e.com/documents/Bulletins/080701.pdf
[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: SLX performance Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Oct 09 8:29 AM
thanks raul! Did not check that . i was looking at the profiler to only get the sql running. Will look into it more closely to get the other timings.

thanks Mike! will check out that doc
[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: SLX performance Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Oct 09 2:18 PM
Mike , Did both the things and Grid is now much much faster............till the user sorts on one column and from that point onwards slow again.

In your screenshots i saw that the column completed date is sorted Desc on Design time. I tried that and still it is slow from that point. Finally to get the rows sorted by Completeddate, i had to enforce an "order by" in the Grid sql in CommonCheckBoxChange(Sender) function in script System:Notes History Common(and hope noone ever dbclick the header to sort)

Next Question: How can i speed up the Columnheader Sort event in a slx grid?

I have all sorts of performance issue with slx in our shop as the app/db server is sitting across a WAN. They are bring in WAN acceleration software from Riverbed systems to boost performance on WAN. Dont know if that is going to help

Thanks!
[Reply][Quote]
Mike Spragg
Posts: 1226
Top 10 forum poster: 1226 posts
 
Re: SLX performance Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Oct 09 2:27 PM
Switch off the "Sortable" property. You will find it much faster as whole grid isn't loaded into memory.
[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: SLX performance Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Oct 09 4:33 PM
That creates a problem where grid.Getcurrentfield returns NULL when No rows returned after Notes filters. Didnt want to complicate further;so left it like that. Now the overall perfmance is much better.

Still the column header DBClick is running slow. It is quite a bit of a learning curve for me;otherwise we should go with slxweb

[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: SLX performance Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 22 Oct 09 1:53 PM
Now everything is in order except for 3 users which includes my ID too
Any idea why the loading should be slow for some and not for all. I debugged and it is showing the time lag at CommonCheckBox Change Sub in the Notes-History common script.
grdHistory.Active = True

Any ideas? I have already cleared the cache and user options

When you login as other in that machine , it is faster. When you login and that user in another machine it is slow. So it is consistent for these userids

I have already cleared the cache and user options and reboot of server and slx/XP client.

[Reply][Quote]
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
 
Re: SLX performance Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 22 Oct 09 2:23 PM
I would suggest you once again plug in the SLX Profiler on that machine.
Get results with one user and then results with the other.
Also, extract the actual queries and compare the resultsets.

[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: SLX performance Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 22 Oct 09 5:08 PM
Thanks Raul!
But i have tried that out already. The Getrows(ms) is way more for these 3 guys who are having a performance issue. I debugged and it is coming to that line where the Grid is made active and that is where it takes time . What next?

Called slx support and they made me overlay a blank DBs plugins table and that is fast.(But there are no groups except the OOTB) So this must be something with groups for these guys.
[Reply][Quote]
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
 
Re: SLX performance Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 22 Oct 09 6:15 PM
You mentioned that the GetRows takes longer for the affected users, have you looked at how much data they have?

How does their record count differs from other users?
Also, how about their Blob sizes?

Modify their queries to figure out how much data they are retreiving out of hte Notes fields:

SELECT SUM(LONGNOTES) FROM HISTORY ..... (ADD YOUR CONDITIONS, ETC).

I don't see how the Plugin table would affect a user's load of a Grid, but then again, SAGE knows better.


GetRows is the time that it takes for the client to receive the actual data, thus my inclination to review the volume of data that they are receiving.
[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: SLX performance Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 23 Oct 09 9:12 AM
Ya, But i always compare apples to apples when it comes to performance testing and have been very successful in the past in various platforms.

Here...
it is the same exact Org and the same conditions. Only thing which differs is the userid of the logged on user. and in debug, if i switch over to a user who do not have these issues the grid refreshes way fast. So this has to be something to do with the data handlers for a slx user.
[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: SLX performance Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 23 Oct 09 9:47 AM
Nevermind. I got it.

Rebuild all indexes in History table and it is fine now. Thanks!
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2020 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 1/20/2020 7:12:25 AM