On Tue, 28 Sep 2004 17:09:14 +0800, ian sison (mailing list) <[EMAIL PROTECTED]> wrote: > > a 320mb/s controller can have about 10 15krpm disks each having > > sustained 30mbps bandwidth. am i right? > > > > As Orly said, it would be a very rare case indeed that you will be > able to saturate the bandwidth of your PCI bus. But having a striped > array of disks will definitely improve your performance more than a > single disk.
The HUGE advantage of a striped setup is that you can do more IOs per second. E.g. 1 disk, 100 IOs per second = 25 INSERTs per second only (if you commit after every row; this is why AutoCommit destroys performance). If you have 10-disk RAID0 strip, you can do 1000 IOs per second because the drives can operate independently of each other. Of course in real life I'm seeing maybe 1500 INSERTs per second using oracle and a very poor IDE hard disk; that's because i insert maybe 500 rows and then COMMIT; that allows the DB and OS to "batch" the disk access and speed things up. -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
