Why my Cache´/ ODBC query is awfully slow?

It's not supposed to be this slow. The query is simple, optimized, performs great in different environment /severs or it just does not make it can be this slow. We're talking about an hour to hour.5 of execution time. It just does not make sense; it was working fine a while back. What's changed?

Suddenly you visit a tab in ODBC Data Source Administrator dialog box that you rarely (maybe) check. The tracing tab. Yes the tracing tab. Tracing was active. Some drivers like Cache odbc driver gives its own logging/tracing; that can slow queries. Because the query itself; its result and statistics about it and its transmission over the network are logged to file. Sometimes every row retrieved is analyzed and logged. This surly slows down your query. You use to debug issues. you if forgotten active, it can be a hidden cause of why queries take too long to come back with results.

Something happened to me a long time ago but wanted to record it here. Sometimes a problem seems daunting, sophisticated etc but the fix is awfully simple.