>>>> I can't exactly recall concrete numbers from the past, but I wonder if >>>> Firebird can currently go beyond > 10MB/s disk I/O utilization. And this >>>> is not about being limited by spinning disk and seek time (random I/O). >>> >>> You'll be wonder if reevaluate concrete numbers... >> >> Firebird 3 or even 2.5? > > Even 1.5 ;)
I'm confused. ;-) With FB 2.5.2 SC 64-bit on Windows 7 Prof. While copying a 18GB database from folder A to B on the same spinning physical disk at ~33MB/s read + ~33MB/s write, thus 66MB/s total, doing a select count(*) on that database (8K page size) for a table with ~6Mio records at a physical disk read rate (according to perfmon) of only ~7,8MB/s. The system has been freshly rebooted, thus the database is not in the file system cache nor in the FB connection page cache. A very naive test, but as I would expect a COUNT(*) with cold caches to be purely I/O bound, with max. ~7,8MB/s we are far away from nearly fully utilizing disk I/O. Regards, Thomas ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
