DBohner-(db)
Legendary Poster
Who\'s got the Biggest F0901 Table?
I've recently been introduced to a client that has gone live in 9.0 - and is having performance issues with their Financial Reporting.
Prior to the GoLive, they restructured their Chart of Accounts.
When looking at the balance sheet (Native) - it runs for HOURS over one company. I see the Calculate Total Revenue function fetches to the F0902 over 138,000 times for that one compay (how unrealistic can that be???). There is only one year of Data in the F0902.
I did a count of the F0901 - and there are almost 8 Million F0901 Records.
We are considering cleaning the F0901 by removing all accounts/records that do not have activity - then, I happened to query the Activity of the F0901.AID against the F0911.AID - and I found the count is over 5.9 of the 8 Million F0901 Records have activity in the F0911. I haven't looked at the F03B11, F4311 and the other ten table...
So, the question - who out there has the biggest F0901 and what do you throw at it from a performance standpoint?
(db)
I've recently been introduced to a client that has gone live in 9.0 - and is having performance issues with their Financial Reporting.
Prior to the GoLive, they restructured their Chart of Accounts.
When looking at the balance sheet (Native) - it runs for HOURS over one company. I see the Calculate Total Revenue function fetches to the F0902 over 138,000 times for that one compay (how unrealistic can that be???). There is only one year of Data in the F0902.
I did a count of the F0901 - and there are almost 8 Million F0901 Records.
We are considering cleaning the F0901 by removing all accounts/records that do not have activity - then, I happened to query the Activity of the F0901.AID against the F0911.AID - and I found the count is over 5.9 of the 8 Million F0901 Records have activity in the F0911. I haven't looked at the F03B11, F4311 and the other ten table...
So, the question - who out there has the biggest F0901 and what do you throw at it from a performance standpoint?
(db)