J
Jimmer
Guest
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
Continue reading...
Continue reading...