Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
New GL system
12-12-2020, 02:41 AM,
#1
New GL system
I mentioned in this thread (http://www.weberp.org/forum/showthread.p...1#pid16201) that we were working on a different system for GL totals that did away with GLPostings.inc and Z_RepostGLFromPeriod.php.

As promised, I have written up a spec here (https://github.com/timschofield/KwaMoja/wiki/_gltotals) and would appreciate any comments. We have this up and running on a test database with more than 2 million gltrans lines and 10 years worth of periods.  There is no noticeable slow down either on GL posting or on GL reports, and without GLPostings.inc it is many times faster on some functions.

I am happy to port this over, but as I have a lot of work on, and am trying to cut down, not take on more, it would need assistance from others.

Tim
Reply


Messages In This Thread
New GL system - by TimSchofield - 12-12-2020, 02:41 AM
RE: New GL system - by TurboPT - 12-12-2020, 10:03 AM
RE: New GL system - by TimSchofield - 12-14-2020, 02:03 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)