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!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Processing of Tabs

Marty05
Posts: 68

Processing of Tabs Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jan 08 4:30 AM

Hi,
Does anyone know this: Does SLX processes tabs (forms) which are not open for the user but shown in "MORETAB"-tab in main view?

We are facing serious performance issues and trying to figure out the reason. I was thinking maybe SLX processes all forms released for the user on opening and changing of contact/account.

Thanks

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Processing of Tabs Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jan 08 4:36 PM

I think that the answer is 'no' - but suggest that you check what is going on by running SLX Profiler while someone is having the issues. It might help you track down queries which are executing slowly. A common cause of bad performance is where accounts have thousands of lines of Notes/History - could this be a factor here? If so, I have seen suggestions elsewhere in this forum to speed things up.

You should also check performance at the SQL Server level - do you have regular maintenance plans running to do your db optimisation?

PP

[Reply][Quote]

Marty05
Posts: 68

Re: Processing of Tabs Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Jan 08 1:11 AM

The Profiler really could help us with this, unfortunately we have 6.2.1 which doenst have the profiler. But we want to upgrade anyway as i think in later versions DB-performance was optimized. Now i use a network sniffer on a VMWare which simulates our current SLX-setting to determine which sqls are posted and to check latency - but this is very time consuming...

but I will check the history / notes of accounts, thats a good hint.

Our problem is, sometimes it takes from 30s to 1 minute to switch from e.g. account to contact. We have now configured SLX profiles in a way that a "all accounts" and "all contacts" group is default at startup - this decreases startup time of course but speeds up the later change of account / contact (as it seems, but not sure....).

we are running Oracle 9.2.0.8 which is maintened regular so this should be ok - but i sometimes have the feeling that oracle is the bottleneck... its so hard to track down the problem. if anyone is having good ideas - very welcome

[Reply][Quote]

Marty05
Posts: 68

Re: Processing of Tabs Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Jan 08 6:07 AM

You were right, tabs only residing in "MORETABS" are not prcessed. One day of networtk traffic sniffing and analysing Oracle Logs i - aehmm - added a messagebox to one tab and yep, the message did only show if tab was active

me idiot, could have saved lots of time if i did this before...

But performance is still a problem...

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Processing of Tabs Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Jan 08 6:44 AM

Quote:

Originally posted by Marty05

... we have 6.2.1..

99% (maybe that's a bit overboard) of your problem is that you are 6.2.1. In SP3 (6.2.3) Sage SalesLogix introduced Virtualized Server Side Cursors to solve performance issues. All versions of SalesLogix (from 6.0 thru 6.2.2) use Client side cursor for everything.. that is the entire recordset w/all data is loaded to the client.

Basically short of upgrading there's very little you can do to solve your performance problems. I would not waste teh time trying to fix a "leak" when there's no bottom in the barrel...

--
RJLedger - rjlSystems

[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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/18/2025 9:21:45 AM