Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 19th January 2017, 15:08
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 568
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Wink 3gl session taking too much time
Baan: Baan IVc4
C/S: Both

This is regarding Baan IVc4.

Hello everyone,

I have created a 3gl session and I am displaying check box for every item group and label object for every item group desc in row column object (DsCrowcolumn).

Also there are two command buttons, "Count" and "Exit". when user selects checkbox of different item group and clicks on Count button, system displays a message showing number of item groups selected.

The ID of every check box created is stored in an array and later on checked if it is selected or not.

The problem is, it is taking too much time to display a message (more than 3 minutes).

I am attaching script for reference. If anybody can have a look and spot the problem.

Vishal
Attached Files
File Type: cln 3gltest.cln (3.8 KB, 29 views)
Reply With Quote
  #2  
Old 19th January 2017, 19:32
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,905
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Debug it - I had to make one change to the code, but it works really well on our test system. It comes up with our item groups - I can click all of them and it takes 2 -3 seconds to pop up the message. I had to add a switch.to.company before the db.nr.rows. But without that it was trying to count in company 000. Now we only have 22 item groups.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 24th January 2017, 12:01
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 568
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Hi Mark,

I tried doing switch.to.company() but there is no improvement.

I also tried to debug the code. One thing I found while debugging is that while trying to check the value of check box (see if it is selected or not) using get.object is taking a bit more time.

Anyone else faced similar issue ? Please help.

Vishal
Reply With Quote
  #4  
Old 24th January 2017, 13:18
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,905
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
I went back and debugged it - every part seems to run nicely, even the get object. I am also running on UNIX platform. We are on like SP33 - not sure any of that helps or not.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
  #5  
Old 24th January 2017, 17:18
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 568
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
We are on service pack 32 and OS is Windows

Vishal
Reply With Quote
  #6  
Old 28th January 2017, 01:32
shah_bs's Avatar
shah_bs shah_bs is offline
Guru
 
Join Date: Jan 2002
Location: Lewisville, Texas
Posts: 387
shah_bs is on a distinguished road
Baan: BAAN IVc3 with A&D2.2b - DB: ORACLE 9 - OS: HPUX
Recompile in profiler mode and check which function is consuming the most time. It will help if you move the user interface related code to their own functions and the data fetch code to their own functions. That way it will be easier to separate which code is using the most time. After that analysis, you can decide the next steps.

I cannot be sure (since I have never used the DsC functions), but I suspect that one of the DsC functions in your particular installation is consuming time. I do not believe the select statements would be the cause of the performance issue. If I am right, and since this seems to be your own session, I would recommend to just use standard BAAN 4GL session and code.

Last edited by shah_bs : 28th January 2017 at 02:26.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
3gl subsession closes main session too theierm Tools Development 8 3rd December 2010 14:09
How to get data of one session to another session - Urgent manish2111 Tools Development 4 21st January 2009 05:21
Users taking a long time to connect to server MattMan Operating Systems & Databases 7 7th January 2009 19:58
running first session after login is taking time veyant Tools Administration & Installation 5 18th August 2003 19:18


All times are GMT +2. The time now is 19:27.


©2001-2017 - Baanboard.com - Baanforums.com