dynamicsusers: Select * FROM and how to do it better in NAV

[Blog bot]

Some background I met with Mark in Barcelona some time back at Tech Ed. We had both just been to a SQL (not NAV related) session, and it opened both our eyes at that moment as to why the Select * in NAV is so bad. I did my first NAV performance tuning job in 1993, (Navision on OS/2 Warp) so I am not new to performance tuning, and since most of my years in NAV have been spent recovering clients form disasters, I generally get to see the worst end of it all. Now-a-days I am seeing a few largish NAV...(read more)

Подробнее... http://dynamicsuser.net/blogs/singleton/ar...ter-in-nav.aspx