* 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
