The ability to disable the SQL, IL and Labda output to save on memory consumption.
The ability to disable the generated SQL, IL and Labda output to save on memory consumption for large queries.
4
votes
Vince
shared this idea
You can disable SQL translation generation as follows:
ExecutionEngine.SqlTranslationsEnabled = false;
The Lambda translation window shows output only for queries that you dump, so it shouldn’t consume memory out of tandem with the results itself. Let me know if you think this is still a problem.
The IL translation only populates when you actually click on the tab.
-
springy
commented
the always active SQL logging makes it impossible to write short data migration scripts targetting 700,000 rows because a 8GB machine runs out of memory just because of the sql logs.