G
gus
Guest
you cannot draw such a conclusion from a single data point. when you are loading data, each data block is accessed several times until it becomes full, after which it is (probably) not accessed again. index blocks will be accessed more times since the btree has to be in order of the index keys. still, the the number of blocks that need to be in memory at the same time will not be terribly large since you are loading a small data set. furthermore, there are other configuration parameters that will affect loading time. regardless of how much time the load takes, it is not a predictor of application performance. -gus > On Oct 16, 2015, at 4:45 AM, Jimmer wrote: > > Update from Progress Community [https://community.progress.com/] > > Jimmer [https://community.progress.com/members/jimmer] > > Hi, > > an update on this (-B sizing) with some "weird" data: > > We moved a 17 GB database (OE 10.2B 05 64 bit) to type II and redistributed the tables/indexes based on RPB values. The server, that is solely hosting the database, has 128GB of RAM, and is running Windows 2008 R2. The database is networked and is being started from OE Explorer. > > We ran a simple procedure that loads (create/import) a ~50 MB table (around 375,000 records) into the database, and the server/database are being restarted prior to each test, anti-virus is off also. > > The load took: > > 1- A little less than 5 minutes with -B set to 800,000 (4k blocksize database, so that's 3.2GB) > > 2- 13 minutes with -B set to 8,000,000 (8 Millions, so that's 32 GB, out of the 128GB available) > > Note: The same result came in whether dbanalys was run prior to the tests or not. > > So to simply translate this, without thinking, a high -B will have a significant bad impact on performance irrespective if the server has more than enough free RAM or not. > > Unless we're missing something. > > Regards, > > Jimmer > > View online [https://community.progress.com/community_groups/openedge_rdbms/f/18/p/17493/73407#73407] > > You received this notification because you subscribed to the forum. To unsubscribe from only this thread, go here [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/17493/mute]. > > Flag [https://community.progress.com/community_groups/openedge_rdbms/f/18/p/17493/73407?AbuseContentId=d6116dcd-cc2a-4ca1-847d-6d31e1f066e1&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true] this post as spam/abuse.
Continue reading...
Continue reading...