Out of memory Exception LinqPad 5
I have just tried to execute a big SQL script of more then 100 MB of sequential Insert statements ( about 270 000 inserts) and after few minutes I get out of memory exception. The application RAM memory consumption constantly increases is at about 3 GB. After some time it just stops with the mentioned exception. Is it possible to override this behaviour somehow?
The example of insert statement:
INSERT [dbo].[ProductWarehouseOverride] ([Id], [SKU], [Warehouse], [IsAvailable], [CreatedAt], [CreatedBy])
VALUES (544580, N'3813071', N'SAVA', 0, CAST(N'2022-12-02T14:43:47.573' AS DateTime), 0)
Comments
LINQPad is not really designed for 100MB scripts. The editor performance won't be great, either, and I don't think it's efficient with SQL Server. Have you thought about using BCP?