I seem to be having some performance issues as well.
I'm using Xcelsius Enterprise 5.3.5.0, Build Number 12,3,5,1128
The query is returning 106 columns and approximately 400 rows. I am only running one QaWS. I initially had 28 queries, but felt that was the reason for the slow performance.
You can test a three levels, to get an idea of where the problem might be.
1. Run the query on the SQL server, within management studio (assuming MS MSQL). How many seconds?
2. Run the query by creating a derived table in your universe. Then, making sure that the number of rows shown in a preview is greater than the number of rows that would be returned by the query, right click on the derived table view rows. This will run the same query and if it's slower, then you have a CMS > SQL Server connection issue.
The SQL statements return the query on average in two minutes. When running the exact query in Webi, it takes about 30 - 45 seconds. When previewing in Xcelsius, it takes upwards of 15 - 20 minutes if successful. I've tested back and forth with a few or no components. Sometimes the application crashes, even when no other tasks are running.
What's the RAM usage like on the client machine opening the dashboard?
The only thing that seems unusual is the large number of columns you're bringing in. i wonder if QaaWS is struggling with this. If you halve the columns, does it halve the load time?
I know this doesn't answer you question, but is it an option to go via Webi and BI Services (or Live Office) rather than QaaWS? You'll get much better speeds, if to-the-minute data isn't important.
One quick question, do you think the performance would increase by creating more queries? For example, is it better to have one large query that I can build components from, or do you recommend creating many queries and data connections?
There is certainly an overhead in establishing a connection, which would suggest that 10 connections returning 10 rows each would take longer than one query returning 10 rows each.
But I don't know how long that overhead is. If you're not sure and you have the time, test both ways, if you can fetch less data overall with more queries, give that a shot.
And yes, XP mode is a snail. What version of Xcelsius are you using? FP3.4 onwards officially support Win7, but from my experience anything from SP3 onwards works fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.