(2013-12-28, 18:44)tuxen Wrote: (2013-12-28, 05:52)allan87 Wrote: (2013-12-27, 16:34)tuxen Wrote: But overclocking away, speed won't matter much if you use USB 2 memory sticks no, because the rely on almost the same memory technology as sdcard's. Move to a good USB 3 stick (closer to SSD technology) or a harddrive and database operations will be insanely faster, as high or higher than the numbers we see with f2fs.
Are you saying that, as a class, usb3 sticks have faster memory? If not, I don't see how there would be a benefit over USB2, as the pi' USB interface is usb2, so the faster interface would not help.
Yes much faster! It doesn't matter if your RPi interface is usb2 there's a massive difference.
Right, let me share some actual results.
These are SD cards in a USB adapter tested in a PC USB2 port:
8 GB Transcend Class 6 micro SD
8 GB Sandisk Class 10 SD (must have aborted before the final test, hence it shows 0.000)
These are USB2 sticks tested in a PC USB2 port:
USB2 HP 16 GB
USB2 Sandisk Cruzer 8 GB
and these are USB3 sticks tested in a PC USB2 port:
USB3 Centon 8 GB ( USB2 port)
USB3 Jetflash700 16 GB (in USB2 port)
So the USB3 results (in a USB2 port) are about the same for writes as the Sandisk Class 10 SD card (in fact the SD beats the USB3 at 4k write speeds by a large margin), so clearly the idea that USB2=SD speed and USB3=SSD speed is ridiculous. The USB2 write speeds are lower than the SD speeds, so USB3 beats USB2 there but the USB2 and USB3 read speeds aren't that much different.
Unfortunately I haven't kept my old test results with my 500GB Samsung HDD in a USB2 enclosure but maybe someone who has a USB2 drive can bench it with CDM to compare with my results.