> 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

You shouldn't go far for the answer, it is written on the next line:

> I am using *Zeoslib* components and Delphi BDS 2006

SY, SD.