Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

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 27th August 2004, 11:42
richard richard is offline
Senior Member
 
Join Date: Oct 2001
Location: France
Posts: 178
richard is on a distinguished road
Baan: triton 3.2/Baan IV/LN - DB: Oracle 9.2.0.6/informix 31 - OS: HP UX 11.23
Number of tables in one database

Hello,

We are managing 15 companies in one oracle 8 database on one single server, i.e. about 40,000 tables.
Our base has about 130 Go in 10 tablespaces.
Our performances and response time are very good.

I have to create a new archieve company and 2500 tables more.

Do you think this number of tables could be a problem ?
Have you some experience with even more companies/tables on one database/server ?

Regards

Richard
Reply With Quote
  #2  
Old 27th August 2004, 12:04
Han Brinkman's Avatar
Han Brinkman Han Brinkman is offline
Guru
 
Join Date: Aug 2001
Location: The Netherlands
Posts: 1,155
Han Brinkman has a spectacular aura aboutHan Brinkman has a spectacular aura about
Baan: All - DB: Oracle/ms-sql/db2 - OS: *nix/windows
No Problem

Connected to:
Oracle8i Release 8.1.7.4.1 - Production
JServer Release 8.1.7.4.1 - Production

SQL> select count(*) from dba_tables where owner = 'BAANDB';

COUNT(*)
----------
80781

SQL>

works fine for many years.

Regards,
Han Brinkman
Reply With Quote
  #3  
Old 27th August 2004, 12:25
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
Hi Richard,

the number of tables is no problem, but you might consider to create a new Oracle instance for archive companies anyway. This will give you some benefits in regards to backup and recovery, if your archive companies become big enough.


Regards

Markus
Reply With Quote
Sponsored Links
  #4  
Old 27th August 2004, 15:15
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
The number of tables can become a problem for your system tables when not using LMT. Several system tables get fragmented and can only be reorganized by re-creating the database. Therefore I advise to use LMT or edit the sql.bsq file before creating the database.

Kind regards,
Dick

PS. Editing the sql.bsq file should only be done by experienced people and can lead to unsupported environments. Therefore I don't give the things that should be changed.
__________________
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
Updating tables in some other database from Baan through a Session? baanprog Tools Development 7 6th July 2004 07:24
Count Number of Records by Tables and Companies NPRao Enhancements 5 12th June 2004 06:15
Database Server Termination on Audited Tables dvlahovic Tools Administration & Installation 2 23rd July 2003 12:52


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


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