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
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 20th April 2005, 18:28
delphin delphin is offline
Newbie
 
Join Date: Apr 2005
Posts: 2
delphin is on a distinguished road
Baan: IV - DB: SQL 2000 - OS: XP/Windows 2000
Question Baan and SQL Server

What performance/tuning does Baan do against a SQL server DB?

I am designing some reports on a site with Crystal and the Baan Solution Kit. I am also a SQL server developer, but the first time I have had a chance to work with Baan. The reports seem to be running a lot slower than I expect them to and I asked how often they do any performance tuning on SQL server. I was told that Baan does all of that and they do not need to touch it.

Is this correct? Or will the normal tuning and maintenance still need to be done on SQL server?
Reply With Quote
Sponsored Links
  #2  
Old 21st April 2005, 01:51
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 710
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
Baan and SQl SERVER

Hi,
If that report duns slower in Baan then it would be slow in Crytal using Baan driver also. Best option would be to use ODBC driver and you can that report performance will improve by many times. The only limitations is that if you have multiple Baan companies then it will be an issue as in database the tables are specific to a company. But once can do some work around solution to overcome that too. We use crytal in our company also. You can email me at apatil@bogen.com

Arvind Patil
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
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 11:49
Can I add more indexes to baan sql server 7 tables lesperancer Operating Systems & Databases 2 31st July 2004 23:34
Upgrade Baan IV (HP-UX, SQL Server 2000) cfasini Operating Systems & Databases 3 20th May 2003 13:56
Should Baan provide a level 2 database driver for SQL server 2000 on BaanIVc4? patvdv Polls and Surveys 6 28th March 2003 13:22
Baanboard.com Community Bulletin 01/05/2002 patvdv About Baanboard.com 0 1st May 2002 15:04


All times are GMT +2. The time now is 11:44.


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