<p>Hi all : is it recommended to have the .ind and the .pag files in Essbase in seperate drives? Doesit really hel p in performance or it does not matter? Also, I'm having a trouble with this editor where I writrethemessage, anything I I type two or three copies ofeverything I type comes after so I had to find a way to avoidthat by using space, does anyone has the same problem? </p><p> </p><p>as a sample ????</p>
<p>Hi<br>I don't think you can have any advantages doing so.<br>moreover it creates extra work when you are migrating from Dev toProd.<br><br>Regarding Trouble in editor....I have the same problem. i am usingtext document<br>to type response and then paste in editor<br>hope this helps<br><br>-----------------<br>email@example.com</p>
<p>Thank you <b>ppasup123 and willjordan</b> for your continuouscontributions and you always have been helpful. As per the .ind and.pag files we have about four applications that have those files indifferent drives, and I’m planning to migrate allapplications to new production server, and I want to do a completebackup, so it’s a hassle to write extra script for just that.I just thought it was recommended to do split them up forperformance purposes.</p><p> </p><p>Thanks again. </p>
If your applications are large and do a lot of I/O (especially writes) having the ind and pag files could have an impact especially if they are on separate controllers. the reduction of head movement could improve performance. Far away and a long time ago (Version 4.12), I tested this and found my application was extremely I/O bound, by separating it onto different disk and controllers, performance improved significantly.
<p>Hi all,</p><p>i have a big problem about calculation performance of somescript in my project. I made some script with a fix command withsome sparse and dense dimensions.</p><p>My PC is a P4 with 1,5 Ghz of RAM.</p><p>The reason of this bad performance is the use of SETCREATENONMISSINGBLK ON command becouse I must calculate to hightlevel of detail. The specific command SET CREATEBLOCKONEQ ON don'trun for all script.</p><p>Could you help me? Could you write me all thesuggestions (commands, cache settings....)? Excuseme for my English <img src="i/expressions/face-icon-small-tongue.gif" border="0">...</p><p>My cube's details are</p><p>3 dimensions dense</p><p>7 dimensions sparse</p><p>existing blocks 60877</p><p>block size 70512</p><p>block density 0,23</p><p>potential number of blocks 1256976000</p><p>average clustering ratio 0,54</p><p>The cache value are default</p><p>Tanks...</p>