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
38%
Installation Wizard into new VRC
41%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 37

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 15th July 2016, 13:42
Ivanus Ivanus is offline
Junior Member
 
Join Date: Sep 2014
Posts: 23
Ivanus is on a distinguished road
Baan: 5.0b - DB: MS SQL - OS: Windows Server
Don't know what it means
Baan: iBaanERP 5.0c
DB: SQL Server 2008 R2
OS: Windows 2008
C/S: None/Unknown

The Session tfgld4410m000 has a very poor performance.
So they ask me the following question:
Have you checked the tables tfgld410, tfgld417 and tfgld418 for instance on database level, reorganize the indexes for instance?
Can anyone explain me what I have to do now ?

Thanks
Reply With Quote
Sponsored Links
  #2  
Old 15th July 2016, 18:24
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,029
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Refer to -
Quote:
Infor Enterprise Server Administration Guide
Document code U8854O US
Release 10.4
Publication date December 12, 2014

Reorganize tables
The system administrator must frequently reorganize the database tables because the disk space of deleted records will not immediately be given back to the system. In other words, although many records in a table are deleted, the size of the table itself will not become smaller. Only after the table has been reorganized will the disk space of the deleted records become available on the system. Reorganizing the database tables becomes very important when many records in tables are deleted.
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
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
what is priority means in inv valuation method whina1100m000 ? quelle Manufacturing & Supply Chain 2 9th November 2010 11:52
Different company numbers means deferent databases? hkrisz79 Operating Systems & Databases 1 9th February 2007 12:45
Freight Management LN nechir Freight Management 1 31st July 2006 15:20
Maintain Two tables by means one sesion gbernal Tools Development 1 24th November 2004 02:25


All times are GMT +2. The time now is 15:38.


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