The queries when executed in ISQL are very fast.
This tells me there is something wrong with my application.
I created a new project to do a test and yes it seems like it's my connection components. I am using Zeoslib.
I will try the latest version of Zeoslib, otherwise it looks like I will have to move to another component library :(