D3 With MsSql 6.5

I have a problem with the speed of getting query from sql server

My DataSource.DataSet is a StoredProcedure in the Sql Server,when i try
to open the SP it takes me about 15-20 sec to run the query and get the
data to the DbGrid.. BUT when i used the Query component and write the
Query in the Sql field of the Query, it runs fast, ( even that the Query
is compiled at runtime)

What's going on here..
please help