I have installed Pentaho CE (6.4 Version) and created cubes in mondrian which is access through saiku. With 5-6 users the performance is really bad. Once user cross 1 the performance start degrading. I have below configuration
8 Core 2.67 Ghz Intel Processor
32 GB RAM
2 MBPS line from datacenter to office
MYSQL 5.5 with database size 4 GB. All tables are indexed and maximum row of table os 500 thousand.
Can any tell me if hardware is anough for 20+ users?
What are the finetuning that can be done to improve the performance.
thanks in advance