Reducing the scope of SQL queries to a single attribute in NAVISION 2009 R2

navision2009R2

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...")

Juhl

No.

But its usually not a problem, as data is cached in nst.

kriki

The only way would be to use queries ... which don't exist in NAV2009R2...
And those are NOT cached in the NAV service tier.

So as Juhl said: "No.".