Home

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

Sign In or Register to comment.