In NAVISION 2009 R2, it seems like NAV always request every attributes
of the records (by sending a "SELECT * FROM"
SQL request), even if I only use a single attribute
of the records (e.g. : via code on a report or via the columns of a form).
Example of an actuel SQL request send by NAV : SELECT * FROM "database_name"."dbo"."company_name$Service Line"
- Isn't NAV compiler supposed to avoid such waste of data ?
- Is there a way (via code or via a NAV/compiler parameter ? ) to force NAV to reduce the scope of the SQL queries to the columns actually used by NAV (e.g : "SELECT Name FROM...")