Re: Best fragmentation strategy

If transaction rate is high, then for records with an access pattern like this I would go for ROUND ROBIN. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Aug 20, 2012 at 5:24 PM, Laurie Gustin <lgustin@utah.gov> wrote: > I have an opportunity to change the fragmentation strategy on some > heavily used tables. Most records on these tables are only accessed on the > day they are written. They are written, read, and updated only once or > twice. Also keep in mind that we are on a SAN, so I have no control over > where the data is physically stored. > > So my question is... is it better to have a different partition for each > day of the month ( only one partition at a time is being heavily accessed) > or to use round robin to theoretically 'spread out' the storage access > across more of the disk. > > Thanks in advance for your opinions > > Laurie > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >