Devart Forums

In my application I use a very complex query. When I run that query in SQL Server management studio it takes 16 seconds to execute the first time and 2 seconds the second time. This is because the query execution plan is created.

When using it from Delphi application it is always like the first time (very slow).

Is it a way I can assign an execution plan to a query or any way I can use sdac to take advantage of this?

Or are you aware to another way to do it even if sdac doesn't support this?

Thanks.

You can call the Prepare method of TMSQuery.

I don't see any sugnificant difference by using Prepare.

Please, check that you call the Prepare method only once, and after that execute a query a few times.

Ok I will try.