with_or_without_trm

Result

BenchmarkClean_MockDB-12           	    1000	    219069 ns/op
BenchmarkClean_SQLite_File-12      	    1000	    767908 ns/op
BenchmarkClean_SQLite_Memory-12    	    1000	     40080 ns/op
BenchmarkTRM_MockDB-12             	    1000	    219373 ns/op
BenchmarkTRM_SQLite_File-12        	    1000	    711622 ns/op
BenchmarkTRM_SQLite_Memory-12      	    1000	     35139 ns/op

sqlite in memory

Different (ns)

Min: 3692; Max: 6268 ; Avg: 5241,2.

Percent

Min: 12,40591398; Max: 21,16780926; Avg: 17,73777683.

sqlite in file

Different (ns)

Min: -31253; Max: 68985; Avg: 4096,4.

Percent

Min: -4,311852939; Max: 10,58490479; Avg: 0,6802981444.

sqlmock

Different (ns)

Min: 9962; Max: 132790; Avg: 49971,2.

Percent

Min: 0,6728880555; Max: 9,04919713; Avg: 3,395166614.

Conclusion

TRM decreases performance about 11% but filesystem or network connection takes significantly longer than TRM.