Go Back > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor


As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
Handover everything to System Integrator from drawing BP till implementation of ERP
Hire more inhouse skilled & capable IT Resource to work directly with SI
Rely on SI Architects/Consultants
Total votes: 11

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 20th April 2005, 19:28
delphin delphin is offline
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
Old 21st April 2005, 02:51
avpatil avpatil is offline
Join Date: Feb 2002
Posts: 784
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
Baan and SQl SERVER

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

Arvind Patil
Reply With Quote
Sponsored Links

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 12:49
Can I add more indexes to baan sql server 7 tables lesperancer Operating Systems & Databases 2 1st August 2004 00:34
Upgrade Baan IV (HP-UX, SQL Server 2000) cfasini Operating Systems & Databases 3 20th May 2003 14:56
Should Baan provide a level 2 database driver for SQL server 2000 on BaanIVc4? patvdv Polls and Surveys 6 28th March 2003 14:22 Community Bulletin 01/05/2002 patvdv About 0 1st May 2002 16:04

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

©2001-2021 - -