SQLite.Benchmark.PayloadSizeBenchmarks-20250713-134620


BenchmarkDotNet=v0.13.5, OS=Windows 11 (10.0.26100.4652)
AMD Ryzen 9 7900X, 1 CPU, 24 logical and 12 physical cores
  [Host]     : .NET Framework 4.8.1 (4.8.9310.0), X64 RyuJIT VectorSize=256
  Job-VDMWCK : .NET Framework 4.8.1 (4.8.9310.0), X64 RyuJIT VectorSize=256

InvocationCount=1  IterationCount=5  UnrollFactor=1  
WarmupCount=2

Method	Size	Mean	Error	StdDev	Median	Allocated
Insert	ExtraSmall	11,514,050.0000 ns	4,849,728.8385 ns	750,500.9061 ns	11,569,500.0000 ns	73728 B
BatchInsert	ExtraSmall	11,861,820.0000 ns	1,199,828.7465 ns	311,591.7152 ns	11,792,700.0000 ns	73728 B
Select	ExtraSmall	840.0000 ns	439.0410 ns	114.0175 ns	800.0000 ns	-
Update	ExtraSmall	700.0000 ns	1,902.3581 ns	294.3920 ns	700.0000 ns	-
Delete	ExtraSmall	0.0000 ns	0.0000 ns	0.0000 ns	0.0000 ns	-
TransactionInsert	ExtraSmall	10,451,240.0000 ns	1,189,707.8251 ns	308,963.3441 ns	10,496,700.0000 ns	81920 B
SelectMultiple	ExtraSmall	1,374,727,460.0000 ns	154,820,679.5164 ns	40,206,438.8158 ns	1,372,914,300.0000 ns	2957040008 B
Insert	Small	21,450,060.0000 ns	3,840,721.5953 ns	997,423.2016 ns	21,603,700.0000 ns	81920 B
BatchInsert	Small	10,452,850.0000 ns	1,108,075.5419 ns	171,475.9167 ns	10,489,900.0000 ns	106496 B
Select	Small	1,000.0000 ns	943.2113 ns	244.9490 ns	900.0000 ns	-
Update	Small	275.0000 ns	618.6884 ns	95.7427 ns	250.0000 ns	-
Delete	Small	80.0000 ns	322.1680 ns	83.6660 ns	100.0000 ns	-
TransactionInsert	Small	18,782,460.0000 ns	11,984,681.4517 ns	3,112,383.7140 ns	19,889,300.0000 ns	106496 B
SelectMultiple	Small	1,342,507,850.0000 ns	90,032,675.2449 ns	13,932,656.1539 ns	1,340,971,100.0000 ns	2957040008 B
Insert	Medium	23,443,560.0000 ns	42,924,227.7351 ns	11,147,285.6310 ns	18,991,300.0000 ns	601184 B
BatchInsert	Medium	21,251,475.0000 ns	7,660,312.0712 ns	1,185,441.7724 ns	21,579,100.0000 ns	2711008 B
Select	Medium	1,694,560.0000 ns	635,973.4867 ns	165,160.2949 ns	1,709,000.0000 ns	1101856 B
Update	Medium	12,051,675.0000 ns	1,313,630.7639 ns	203,285.8148 ns	12,105,950.0000 ns	1686680 B
Delete	Medium	1,679,960.0000 ns	804,798.3346 ns	209,003.5717 ns	1,620,800.0000 ns	65536 B
TransactionInsert	Medium	13,140,980.0000 ns	3,049,090.7674 ns	791,839.1895 ns	12,876,100.0000 ns	1664288 B
SelectMultiple	Medium	1,406,283,300.0000 ns	118,259,271.5498 ns	30,711,557.2727 ns	1,406,429,400.0000 ns	2957040008 B
Insert	Large	65,581,000.0000 ns	127,109,959.9805 ns	19,670,407.0087 ns	57,641,900.0000 ns	26303584 B
BatchInsert	Large	243,688,780.0000 ns	115,883,296.4547 ns	30,094,524.0857 ns	244,181,400.0000 ns	131223008 B
Select	Large	19,062,480.0000 ns	6,285,046.7022 ns	1,632,206.6695 ns	18,150,400.0000 ns	59834544 B
Update	Large	54,048,975.0000 ns	8,583,850.6110 ns	1,328,360.3838 ns	54,107,400.0000 ns	86121768 B
Delete	Large	1,327,950.0000 ns	253,505.7984 ns	39,230.3029 ns	1,339,950.0000 ns	65536 B
TransactionInsert	Large	120,111,975.0000 ns	14,230,022.9730 ns	2,202,111.8067 ns	119,491,850.0000 ns	78771488 B
SelectMultiple	Large	1,091,462,900.0000 ns	61,286,311.5124 ns	9,484,124.5461 ns	1,095,923,050.0000 ns	2957040000 B
Insert	ExtraLarge	403,595,860.0000 ns	31,685,015.8399 ns	8,228,497.9934 ns	403,831,400.0000 ns	262233232 B
BatchInsert	ExtraLarge	2,021,072,525.0000 ns	181,902,605.5689 ns	28,149,629.5650 ns	2,011,313,700.0000 ns	1310871248 B
Select	ExtraLarge	169,243,800.0000 ns	25,519,208.8317 ns	3,949,125.8147 ns	167,908,850.0000 ns	530645272 B
Update	ExtraLarge	387,588,850.0000 ns	50,951,880.2744 ns	7,884,859.8726 ns	391,109,600.0000 ns	792862120 B
Delete	ExtraLarge	1,346,525.0000 ns	511,174.9084 ns	79,104.8829 ns	1,331,050.0000 ns	65536 B
TransactionInsert	ExtraLarge	1,146,242,425.0000 ns	50,682,667.9091 ns	7,843,198.9610 ns	1,147,020,050.0000 ns	786560432 B
SelectMultiple	ExtraLarge	1,146,523,740.0000 ns	101,708,533.8895 ns	26,413,383.2615 ns	1,142,519,000.0000 ns	2957040008 B