Sage 100

I am working with a 2017 Advanced user where a sizeable (< 500 MB) table read via ODBC sometimes takes 10 times longer than usual. It normally takes 2-3 minutes, but 1 or 2 times per week it takes 30 minutes - it always completes successfully. The failures aren't always with the same table, just large ones. The (recently rebuilt) tables involved are SO_SalesOrderHistoryHeader and Detail. All users are out of the system and I am using MS Access to read the ODBC via a pass-though query. No other server activity (e.g. backups or other resource competition) is apparent. Has anyone else see this odd behavior or have any ideas? TIA

Are you accessing directly from the server, not workstation?

CS-ODBC not enabled for the user?

From the server and w/o CS-ODBC enabled.

Generally speaking, with ProvideX ODBC you'll get a faster result if your SELECT query can explicitly ORDER BY the key fields. I've seen 30 minute response times with AR_InvoiceHistoryDetail when it doesn't. So in your case if possible with your PTQs, if not already this way, you might consider doing it like this: SELECT * FROM SO_SalesOrderHistoryHeader ORDER BY SalesOrderNo SELECT * FROM SO_SalesOrderHistoryDetail ORDER BY SalesOrderNo, SequenceNo