Okay, if I connect using ISQL and execute the query its pretty darn fast
I can only assume something is wrong with my connections or datasets.
The problem is I have no idea what

I am using Zeoslib components and Delphi BDS 2006