You are not logged in.

Speed-up Palo performance

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

andika_p

Intermediate

  • "andika_p" is male
  • "andika_p" started this thread

Posts: 7

Date of registration: Feb 18th 2009

Location: Semarang

Hobbies: IT programming

  • Send private message

1

Tuesday, August 11th 2009, 5:31pm

Speed-up Palo performance

Hi,

I have problem with Palo peformance.
there are 12 dimensions with many elements inside.
Customers (element => Total region, region, and customer name as a child element),
Products (element => total product, material type, product range, and item name as a child element),
Documents,
Order Type,
Customer type,
measure,
years,
month,
etc


and I am using PALO.DATAC to retreive the data.
MY excel reports, there are several sheets
1. monthly turnover
2. material turnover

and I want to add once more as 'Range Turnover' which retrive from Product dimensions.
but after add this, Palo is going slow and slow. if I delete this sheets, Palo works normall again.
there are about a hundred ranges

how to speed up this performance?

I already set Palo configuration file:
Chache-size 0
Chache-barried 5000

but it doesnot help to speed up the performance..

best regards

andika_p

Intermediate

  • "andika_p" is male
  • "andika_p" started this thread

Posts: 7

Date of registration: Feb 18th 2009

Location: Semarang

Hobbies: IT programming

  • Send private message

2

Thursday, August 13th 2009, 11:14am

Can somebody help me about my below questions?

Michel

Sage

  • "Michel" is male

Posts: 154

Date of registration: Jun 1st 2007

Location: Netherlands

  • Send private message

3

Thursday, August 13th 2009, 11:52am

Hi,

If I understand you correctly you're building a (big) Excel workbook with multiple sheets, each containing a (big?) view on your cube.
If this is the case then each time you make a change (when automatic calculation is on in Excel) all cells in all sheets in all open workbooks are calculated. This can slow down performance considerably.
Changing the palo.ini cache setting will not help much in this case.

You could start by switching off automatic calculation (if not done already) and use <SHIFT>-<F9> to recalculate the active sheet (instead of all sheets in all open workbooks).

You could also reconsider your design - do all reports need to be open at the same time? If not, you could split your workbook in multiple ones, so that you're able to only open the reports you need at the time.

Please note that if you use subsets containing the DFILTER/SUBCUBE functions this can also slow down performance.


Michel

Benh

Intermediate

Posts: 8

Date of registration: Aug 4th 2009

Location: Flensburg

Occupation: Student

  • Send private message

4

Thursday, August 13th 2009, 7:41pm

Hello,

first Michel is right, you should switch off automatic calculation or create a check whether the worksheet is opened and let the function only retrieve data if so. Second you should use PALO.DATAV (array function) whereever you can as it is much faster thn PALO.DATAC (see manual for further information). Third, are you using rules? This might slow down all queries, especially if the add-in retrieves the data for the whole workbook.

Regards
Ben

Huckly

Master

  • "Huckly" is male

Posts: 34

Date of registration: Nov 10th 2005

Location: Germany

  • Send private message

5

Thursday, August 13th 2009, 11:34pm

Hello,

i think the cache barrier is your problem. Set cache barrier to 500000000 and try it again.

Greetings
Huckly
Greetings from South Germany :P
Huckly
Rate this thread