no, translation is not a problem here ... i did a little research on
topic "Master planning".
It seems that master planning uses table "InventSumLogTTS" a lot.
Every time a row in "InventTrans" table is deleted it creates a row in
"InventSumLogTTS" table. now ... you can imagine that lots of delete()-s
are being made every day. And this table ("InventSumLogTTS") grows very
big.
And now the "master planning" ... when no ranges are being specified on
"InventTable" (while running master planning periodic menuitem) this
table is being emptied. Somehow it takes very long to delete the
contence of this table. * Why is that? * I don't know. I noticed though,
that class "ReqCalcScheduleItemTable" makes use of "UserConnect" class a
lot. As I understand it creates a new connection to database and
executes SQL queries through that connection. But i'm not sure.
Anyway ... we decided to empty that table "InventSumLogTTS" by hand
(directly in SQL manager) and after that master planning took 3
minutes... for all items.
If someone knows exactly for what this table is being used ... i'm all
ears :)
________________________________
From: Pieter Wijnen [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 07, 2004 2:28 AM
To: [EMAIL PROTECTED]
Subject: SV: [development-axapta] Master planning/Master scheduling ...
Translation to SQL problem (me thinks), Microsoft aka navision aka
damgaard (in this context), never sought a solution to the NULL problem
(in my opinion) - instead they've chosen to ignore it (using chr(2)
for "empty" strings, 0 for "empty" numerals & 1-jan-1900 for "empty"
dates- however, in this particular case they've probably had to build
pretty elaborate logic to make a NULL response equal to a * response (ie
assuming ALL for NULL)
.. been there, done that
Pieter
Life'd been (grammatically) simpler if NULL had not been defined as NULL
but as UNDEFINED (which it mathematically is)
-----Opprinnelig melding-----
Fra: Janno Liivak [mailto:[EMAIL PROTECTED]
Sendt: 6. oktober 2004 10:26
Til: [EMAIL PROTECTED]
Emne: [development-axapta] Master planning/Master scheduling ...
Hi
Axapta 3.0 SP2
MS SQL Server 2000
Does anybody know why, when executing Master scheduling in Master
planning/Periodic/Master scheduling ... when you don't specify item,
scheduling runs a lot slower than when you set "*" as item filter?
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129oetcpo/M=295196.4901138.6071305.3001176/
D=groups/S=1705006764:HM/EXP=1097137723/A=2128215/R=0/SIG=10se96mf6/*htt
p:/companion.yahoo.com>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=461091464>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129n9o1i7/M=294855.5468653.6549235.3001176/
D=groups/S=1705006764:HM/EXP=1097213156/A=2376776/R=0/SIG=11ldm1jvc/*htt
p://promotions.yahoo.com/ydomains2004/index.html>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2376776/rand=485716082>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.