"Hi Jamie,
I think, even that Alchemex turned off all calculations, when you refresh the formula in Excel, it will still take time for populate/update the file.
It is always quicker to have the work done in database level, ie, either base your…"
-
Jaime Schmulson
- Male
- Spring, TX
- United States
- Blog Posts
- Discussions (3)
- Groups (1)
- Photos
- Photo Albums
- Videos
Jaime Schmulson's Discussions
SAI vs. Crystal performance issues.
5 Replies
Has anyone come across performance issues when converting Crystal Report to SAI? We’re consolidating multiple SQL databases to provide a single 401K report. The reports in Crystal, using sub reports…Continue
Tags: Performace, Speed, Crystal, SAI
Started this discussion. Last reply by Shwu Hua Gan Apr 23.
Jaime Schmulson's Page
Latest Activity
Jaime Schmulson replied to Jaime Schmulson's discussion SAI vs. Crystal performance issues."Thanks... I understand the power after the data is there, but the overhead has to be overcome with more powerful PCs. In the meantime, the users has to wait.
I ran a timing comparison after noticing the speed issue. Most of the times, 80%, the…"
Allan Smallie replied to Jaime Schmulson's discussion SAI vs. Crystal performance issues."You are correct in that ALX does have an increased overhead due to the process of retrieving the data. This said, I've never had an issue with this before, as the added functionality provided is significantly more important that a longer…"
Jaime Schmulson replied to Jaime Schmulson's discussion SAI vs. Crystal performance issues."Thanks....
What should I check on the ODBC? This are created by SAI/Accpac.
Just tested the Statments (normal links) on the largest database, it takes 7 seconds, all other 6 databases take less than 1 second each.
I don't think the problems is…"
Allan Smallie replied to Jaime Schmulson's discussion SAI vs. Crystal performance issues."A few thoughts...
Look at the configuration of your ODBC connections that are used within the container. Perhaps they are causing the bottleneck. Are they the same ones used by Crystal?
Are your views running efficiently? ie not cumbersome and…"
Jaime Schmulson posted a discussionSAI vs. Crystal performance issues.
Has anyone come across performance issues when converting Crystal Report to SAI? We’re consolidating multiple SQL databases to provide a single 401K report. The reports in Crystal, using sub reports is taking 45 seconds, in SAI almost 20 minutes.
Jaime Schmulson replied to Ruth Gray's discussion Sage Accpac Intelligence Container Data Dictionary (SQL) in the group Sage Accpac Intelligence"I was coincidentially looking at the Ytd#YrAgo... Very intersting, but noticed that one or some of the formulas are incorrect. When going from the 4yrs it has a -4 then the 3yrs has a -2... I wonder if the 4yrs should be a -3"
Profile Information
- Alchemex Powers the Following BI Solution, Pick Yours
- Sage Accpac Intelligence
- Website
- http://AdvancedApplications.com
- About Me:
- Sage Accpac ERP and CRM Tech Support Manager. Develope integration from external applications into Sage Accpac and ERP, customize around Accpac and ERP.
- How long have you been using the above solution?
- 11 years
- Where did you hear about us?
- Other
- If other, please specify
- Sage
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
