Sage 100

 View Only
  • 1.  Any tricks to speed up Sage Intelligence?

    Posted 06-13-2025 16:23

    A client of ours has a Sage Intelligence report for Financial Statements.  This report is a Union report that pulls 10 sub reports.  The data rendering takes quite a bit of time; about 10 - 15 minutes. The time crunch is pulling a bunch of GL Detail data.

    My question is whether using SQL would speed this process up.  Does anyone have any experience of time differences between Providex and SQL databases for Sage Intelligence reports? 



    ------------------------------
    Chuck Peddy
    Smartbridge Partners
    ------------------------------


  • 2.  RE: Any tricks to speed up Sage Intelligence?

    Posted 06-13-2025 16:53

    SI use the ODBC link to pull the data?  If so, I would expect Premium to pull the data faster.

    10 - 15 minutes doesn't seem like a long wait in the big scheme of things.......



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------



  • 3.  RE: Any tricks to speed up Sage Intelligence?

    Posted 06-13-2025 16:59

    Have a client who switched from Biznet to SI and sped up their reports from 2 hours to 10 minutes.  I was amazed - I figured all of those programs were basically the same.



    ------------------------------
    Beth Bowers
    Dog Mom, first and foremost. The rest is all just necessary to keep the dogs in biscuits.
    (269) 358-0989
    ------------------------------



  • 4.  RE: Any tricks to speed up Sage Intelligence?

    Posted 06-13-2025 18:00

    I'll bet Biznet is not using the Sage version of ODBC. That data connection is something to always keep in mind. 



    ------------------------------
    Jerry Norman
    Smartbridge Partners
    (512) 653-7498
    ------------------------------



  • 5.  RE: Any tricks to speed up Sage Intelligence?

    Posted 06-13-2025 18:01

    We are curious about whether these Sage factors matter to downloading SI Data:

    • 64-bit Sage 100
    • 64-bit ODBC
    • Sage Premium/SQL

    Thanks!



    ------------------------------
    Jerry Norman
    Smartbridge Partners
    (512) 653-7498
    ------------------------------



  • 6.  RE: Any tricks to speed up Sage Intelligence?

    Posted 06-14-2025 17:07

    You might try adding a filter to the sub reports to limit the detail pulled into the reports. If they only need two years of data, then limit the pull to two years.



    ------------------------------
    Bill Pfahnl
    Nims & Associates
    ------------------------------