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

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 50

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 15th July 2016, 12: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 ?

Reply With Quote
Old 15th July 2016, 17:24
NPRao's Avatar
NPRao NPRao is offline
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,064
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows
Refer to -
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
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
what is priority means in inv valuation method whina1100m000 ? quelle Manufacturing & Supply Chain 2 9th November 2010 10:52
Different company numbers means deferent databases? hkrisz79 Operating Systems & Databases 1 9th February 2007 11:45
Freight Management LN nechir Freight Management 1 31st July 2006 14:20
Maintain Two tables by means one sesion gbernal Tools Development 1 24th November 2004 01:25

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

©2001-2018 - -