I am running the same query from crystal reports and excel vba.
The crystal reports runs in about a second.
Excel VBA takes 26 seconds.
They both are going through the same ODBC connection.
The query comes directly from crystal reports > Database > Show SQL query
The vba code is simple...