Performance issue

Business Central/NAV Developers Forum
1

Hello Experts,

I am trying to export data from 2 linked tables through NAS to the flat text file in NAV 2009 R2.

But these tables have a huge data and keep increasing every day.

It is running 8mins for just traversing both tables.

Please any one have suggestion to improve performance.

Thanks in Advance,

Shravan

2

if you do really only Export the data (no validation, etc. needed) then you could Export the data direkt from the SQL tables. also check exporting with powershell cmdlets.

3

use the SQL Server tool bcp.

http://msdn.microsoft.com/en-us/library/ms175937(v=sql.105).aspx