You are not logged in.

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.

dick

Master

  • "dick" is male
  • "dick" started this thread

Posts: 38

Date of registration: Mar 5th 2007

Location: Hamburg

  • Send private message

1

Wednesday, December 5th 2007, 10:17am

Optimization of windows environment

Hi,
sorry for asking general windows topics in this forum. But I need some help to reduce the calcluation time of Palo.
Our server is equipped with 2 GB of memory but according to the task manager it looks as if Palo uses only some 470 MB. But: the number of page faults is more than 1.000 every second which might be the reason for slow recalculation. Which settings can help either in windows or in Palo.ini to make more efficient usage of the 2 GB?
Regards
Martin
dick has attached the following image:
  • Speicher wg Palo.jpg

Enno

Palo Team

  • "Enno" is male

Posts: 56

Date of registration: Dec 13th 2007

  • Send private message

2

Tuesday, January 8th 2008, 11:01am

Are you using palo2.0?
If you are using palo2.0 how did you setup your cache?

Regards
Enno

dick

Master

  • "dick" is male
  • "dick" started this thread

Posts: 38

Date of registration: Mar 5th 2007

Location: Hamburg

  • Send private message

3

Monday, January 28th 2008, 3:49pm

Hi,
thanks for your answer. Yes, I use 2.0 but left the cache parameter at the default value (5000). Recently I increased this value to 10.000 but could not realize any change.

The speed to recalculate data for one specific spreadsheet is extremely different. Sometimes it's abolutely OK, five minutes later it takes hours to react (if I don't close the EXCEL-file to terminate recalculation).

Due to the column which shows memory usage in the task manager I am in doubt that additional memory can help. But I wonder why Palo doesn't use more memory (currently the server is equipped with 2 GB and the task manager shows 478.348 kB in use by Palo).
Regards
Martin

Rate this thread