ADO : "FMTONLY ON" and "exec sp_executesql"

Thread View: borland.public.delphi.database.ado-net

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Brent Fri, 26 May 2006 14:19

#20

Author: Brent
Date: Fri, 26 May 2006 14:19

18 lines
1209 bytes

Hi there

I've recently ported a Delphi 5 & BDE app to D2006 vcl.Net & ADO.

The SQL when viewed in profiler now has many referneces to :

exec sp_executesql....
	and
SET FMTONLY ON...

Is there a way to turn this "off" and only run the raw SQL as the BDE did ?

I've read that this might improve performance abit, as the app is now 
painfully slow.

Many thanks

Brent

Re: ADO : "FMTONLY ON" and "exec sp_executesql"

#21

Author: Ralf Jansen
Date: Fri, 26 May 2006 15:25

27 lines
1617 bytes

Set Paramcheck to false on your Dataset if you are not using parametrized SQL.
This should get you rid of most of the SET FMTONLY statements.

sp_executesql is normal when executing sql with parameters.

Ralf

Brent schrieb:
> Hi there
> 
> I've recently ported a Delphi 5 & BDE app to D2006 vcl.Net & ADO.
> 
> The SQL when viewed in profiler now has many referneces to :
> 
> exec sp_executesql....
>     and
> SET FMTONLY ON...
> 
> Is there a way to turn this "off" and only run the raw SQL as the BDE did ?
> 
> I've read that this might improve performance abit, as the app is now 
> painfully slow.
> 
> Many thanks
> 
> Brent
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads