Recent

Author Topic: SLOW ODBC - Sage 100  (Read 1403 times)

mm_coder

  • New Member
  • *
  • Posts: 43
SLOW ODBC - Sage 100
« on: December 09, 2020, 08:22:06 am »
Not trying to be rude, but also not sure if the original post (text below) was in the correct forum...so I re-posted here.
I will add, that I'm going to try using LibreOffice Base to see the behavior of ODBC speed as well as the below post.
So far it looks like Lazarus ODBC speed for this particular DB (ProvideX) is needing some tweaking, but not sure.
Best

Using Lazarus to connect to Sage 100 ProvideX db using ODBCCONN.

Condition 1: When the Sage 100 ERP client is open on a client machine (Win 10 or Win 7), an ODBC connection
takes approx 4 seconds.

Condition 2: When the Sage 100 ERP client is NOT open on a client machine (Win 10 or Win 7), an ODBC connection
takes approx 1 seconds.

Anything I should know regarding ODBC parameters that may make this work better?

An Access application using the same ODBC driver has no delay regardless of Sage client state.

Regards,

 

TinyPortal © 2005-2018