IDS chunk size
Hi all, We would like to know about the chunk size, which we can set for the database stripping. Example is as follows: Database size: 200GB (RAW DISK mode) Stripped Data size: 2GB That means, 100 stripes of 2GB, which will become 200GB Database. In IDS 9.x, the Chunk size has been increased to 4GB from 2GB limitation from IDS 7.x versions. If we increase the chunk size from 2GB to 4GB, will it increase the performance or decrease the performance? If it will increase the performance, kindly let me know at what level it will start decreasing the performance. Apart from this if you guys have any details about the kernal settings for Informix DS 9.4 versions, kindly send the same to me on arvind.patkar@gmail.com/ dbbimail@gmail.com Thanks and regards, Arvind.
Hi Arvind, Whether or not you'll see any performance increase depends on many factors. One of those factors is whether or not you use read-ahead or light scans. In either of those cases, the larger chunks might mean some improvement in I/O response time. Its possible that I/O latency will not be improved, and its likely that there won't be any measurable effect on the overall DBMS performance from this single change. Also note that the size increase for each chunk is not from 2GB to only 4 GB, but to 4 terrabytes (TB). That would mean you could fit your entire database in one chunk. Cheers, Dick Snoke Consulting IT Specialist dsnoke@us.ibm.com 404 487 1595 "ARVIND PATKAR" <dbbimail@gmail.com> Sent by: forum.subscriber@iiug.org 02/04/2005 04:38 AM To ids@iiug.org cc Subject IDS chunk size [4165] Hi all, We would like to know about the chunk size, which we can set for the database stripping. Example is as follows: Database size: 200GB (RAW DISK mode) Stripped Data size: 2GB That means, 100 stripes of 2GB, which will become 200GB Database. In IDS 9.x, the Chunk size has been increased to 4GB from 2GB limitation from IDS 7.x versions. If we increase the chunk size from 2GB to 4GB, will it increase the performance or decrease the performance? If it will increase the performance, kindly let me know at what level it will start decreasing the performance. Apart from this if you guys have any details about the kernal settings for Informix DS 9.4 versions, kindly send the same to me on arvind.patkar@gmail.com/ dbbimail@gmail.com Thanks and regards, Arvind.
ARVIND PATKAR said: > > We would like to know about the chunk size, which we can set for the > database stripping. Example is as follows: > > Database size: 200GB (RAW DISK mode) > Stripped Data size: 2GB > > That means, 100 stripes of 2GB, which will become 200GB Database. > > In IDS 9.x, the Chunk size has been increased to 4GB from 2GB limitation > from IDS 7.x versions. 4TB, actually. > If we increase the chunk size from 2GB to 4GB, will it increase the > performance or decrease the performance? If it will increase the > performance, kindly let me know at what level it will start decreasing the > performance. It depends. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco You are better at sex than anyone. Now all you need is a partner. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed http://members.rogers.com/2remedy/images/smilies/banners/RTFM.gif