Data Compression in NAV 2016 - Report Performance

djswim

Does using data compression on a regular basis speed up the time to run reports which rely on a culmination of ledger entries, like the Inventory Valuation report?

This is an environment that is very high transactions (Item Ledger Entries) and very high number of Items, as well as quite a few locations.

Thanks in advance!

TallyHo

Yes, if you can safely compress f.i. 100 entries to just 10, your report will be faster.

djswim

And this is done via SQL in 2016, correct? I'm not seeing Item Ledger Entries in here:

TallyHo

It (item ledger compression) once was there, but it seems to have been dropped:
https://dynamicsuser.net/nav/f/users/88820/3rd-party-date-compression-on-item-ledger-entry-table-value-entry-table

"And this is done via SQL in 2016, correct? I'm not seeing Item Ledger Entries in here"
Not that I'm aware. Normally it's done in C/AL so the sql server version doesn't really matter.