Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 12th March 2008, 12:40
rh77473 rh77473 is offline
Junior Member
 
Join Date: Mar 2008
Posts: 4
rh77473 is on a distinguished road
Baan: triton, baaniv, baanerp - DB: bisam, oracle - OS: solaris
Performance client/server mode
Baan: Baan IVc4
DB: Oracle 10.2.0.x
OS: Solaris 10 (SunOS 5.10)
C/S: Both

Hi All,

Is there anybode who has experience with tuning Baan and Oracle running in client/server mode?
I have a customer who wants to switch from hostmode to client/server mode. They are using Baan IVc4 and want to use oracle 10.2.0.3.0.
When running is hostmode performance is fine. Eg printing all Articles within 15 seconds. When running the same session in client/server mode the same
session took about 5 minutes.
I am wondering if special tuning is necessary for running in client/server mode. Network looks ok. It is a 1Gbit/s network and eg ftp large files is no
problem.

Thanks in advance.

Richard
Reply With Quote
  #2  
Old 13th March 2008, 00:22
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
there isn't much tuning specific to a 3 tier setup. most likely it is something to do with the network (duplex settings, packet sizes, etc.)

Otherwise it could be something they did in the actual move. (export/import oracle but didn't re-create statistics, re-installed oracle but didn't bother to tune it.. etc.)

Dave
Reply With Quote
  #3  
Old 17th March 2008, 16:22
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
I agree with Dave. Some more things that could be tested:
- Did everything became slow, or a few sessions? If everything became slow, than we have to suspect the setup, else we have to determine what has changed.
- Do you have a dedicated network between app and db server? It is advised to do so as the application server can generate quite some traffic.
- Can you check if the connection is setup properly? Can the the database server be resolved quickly etc.

Hope this helps,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #4  
Old 25th March 2008, 11:14
rh77473 rh77473 is offline
Junior Member
 
Join Date: Mar 2008
Posts: 4
rh77473 is on a distinguished road
Baan: triton, baaniv, baanerp - DB: bisam, oracle - OS: solaris
Thanks for the information.
Customer is also using oracle 10.2.0.3. There are some performance issues
known in this oracle release. Customer will first install the patches to see
if this helps.

And yes, everything became slow. There is a dedicated network between
app and db server. Connection looks ok.
Reply With Quote
  #5  
Old 24th April 2008, 23:35
NvanBeest's Avatar
NvanBeest NvanBeest is offline
Guru
 
Join Date: May 2003
Location: South Africa
Posts: 521
NvanBeest is on a distinguished road
Baan: BaanIVc4 - DB: Oracle, TBase, SQL Server - OS: AIX, Linux, Window$
Which connection are you using? Oracle SQL*Net or Baan?

Or, if the problem has been resolved, what was it?
__________________
Regards,
Nico
Reply With Quote
  #6  
Old 30th May 2008, 19:07
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Guru
 
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
there are a few SQL net settings, which might be beneficial and if the problem still exist, then I will did them up for you.

Apart from that, for a single user host mode is always faster, than client-server, simply due to the network overhead. The question is, how many users do you need, so that client-server starts making sense?

In the last 10 years I have seen many customers going from client-server to hostmode due to that reason. Single HW boxes bacame so fast, that even for a 1000 user installation, hostode is better than client-server. I have a real life example of this of a customer running on HP-Ux in Switzerland.

Regards

Markus
__________________
Markus Schmitz
Senior Consultant
SOFTimpact Ltd.
Reply With Quote
  #7  
Old 3rd September 2008, 17:30
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
Richard,

Any updates on this issue? Like to hear what the problem was and how you solved it.

best regards,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #8  
Old 4th September 2008, 12:17
rh77473 rh77473 is offline
Junior Member
 
Join Date: Mar 2008
Posts: 4
rh77473 is on a distinguished road
Baan: triton, baaniv, baanerp - DB: bisam, oracle - OS: solaris
hallo Dik,

Customer has installed the oracle patch and it was ok after that.

Regards,

Richard
Reply With Quote
  #9  
Old 4th September 2008, 12:21
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
Richard,

*The* Oracle patch does not exists . Can you be a bit more specific what kind of patch they installed? In 3-tier it could well be that they upgraded the client aso to 10g or so.

Best regards,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #10  
Old 5th September 2008, 07:52
rh77473 rh77473 is offline
Junior Member
 
Join Date: Mar 2008
Posts: 4
rh77473 is on a distinguished road
Baan: triton, baaniv, baanerp - DB: bisam, oracle - OS: solaris
they are now using oracle 10.2.0.4
Reply With Quote
Sponsored Links
  #11  
Old 1st November 2008, 19:07
Cesar Lopez Cesar Lopez is offline
Member
 
Join Date: Jul 2006
Posts: 31
Cesar Lopez is on a distinguished road
Baan: ERP Baan V - DB: Oracle 9i - OS: HP-UX 11i
Dba

this is more related to db configuration check SGA, PGA, stats, not to have recycle bin parameter, the same version of oracle server and client,and in baan check $BSE/lib/defaults/db_resource review this parameters:

use_shm_info
ora_max_array_fetch
ora_max_array_insert

Regards
Reply With Quote
  #12  
Old 11th October 2013, 15:54
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
Tableboosters normally don't gain a lot. A maximum of 10% is expected.

Parallel bshell on its turn can gain a lot of performance.
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
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
performance dll Hitesh Shah Code & Utilities 11 2nd March 2009 14:29
SSA ERP LN6.1 Installation - Server Mode brkoga Tools Administration & Installation 1 8th April 2006 02:59
Use of performance boosters - errors... r_nagu Tools Administration & Installation 17 17th August 2004 18:24
Page mode usage? reintjan Polls and Surveys 6 28th January 2003 17:18


All times are GMT +2. The time now is 07:25.


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