This discussion is archived
6 Replies Latest reply: Jul 31, 2007 12:18 PM by 3004 RSS

Essbase performance

3004 Newbie
Currently Being Moderated
<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>
  • 1. Essbase performance
    3004 Newbie
    Currently Being Moderated
    <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>ppasup1@gmail.com</p>
  • 2. Essbase performance
    3004 Newbie
    Currently Being Moderated
    Most of the time, the .ind file fits into the index cache, so there is no IO there anyway. So as a general rule, .ind and .pag files can live on the same drive with no difficulty.
  • 3. Essbase performance
    3004 Newbie
    Currently Being Moderated
    <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&rsquo;m planning to migrate allapplications to new production server, and I want to do a completebackup, so it&rsquo;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>
  • 4. Essbase performance
    3004 Newbie
    Currently Being Moderated
    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.
  • 5. Essbase performance
    3004 Newbie
    Currently Being Moderated
    <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>
  • 6. Essbase performance
    3004 Newbie
    Currently Being Moderated
    rino, make a NEW topic to ask your question and you will probably get better responses.