So maybe this particular SSD is slow with write barriers, while other doesn't have a problem with it (as they don't change performance between SATA and USB3).
2014-03-23 22:18 GMT+01:00 Florian Weimer <f...@deneb.enyo.de>: > * piotr maliński: > > > The usb3 case has asmedia chip and phoronix sqlite insert benchmark runs > > around 6 times faster than when running via sata. Some benchmarks like > > untaring, some iozone benchmarks do not differ so I'm suspecting > controller > > or OS issue. Does sqlite insert uses some specific I/O operations? > > Yes, write barriers. Many USB SATA adapters do not handle them > properly, leading to significant speed-ups and increased risk of data > loss. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users