RE: fragmenting tables with RAID1

>===== Original Message From "John Stephenson" <JStephen@ctr.pcusa.org> ===== >Has anyone had any experiences, good or bad, using table fragmentation in >combination with RAID1 for their dbspaces? > >I like the idea of being able to intelligently distribute the data by >expression across disks, and the safety of mirroring, but I'm afraid it's >going to be slow. Why? What exactly are you afraid is going to be the slow down? > >We're using it for web applications and are more interested it read >performance than writes. I'm not planning on using PDQ for the apps because >of the number of users. How large are the most active tables in this database, and what size machine will you be running the database on? Are you storing images in the database? The database for our website is able to keep the information describing the layout of the site cached. Due to this, the speed of disk reads does not often effect the speed with which someone navigates are site. For us the biggest slowdown is the time it takes for all the pictures to get from the webserver to the client. Will ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------