U++ framework: U++ SQL » OleDB + parameters = problem

Home » U++ Library support » U++ SQL » OleDB + parameters = problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: OleDB + parameters = problem [message #19789 is a reply to message #19786]

Tue, 20 January 2009 23:34

Novo
Messages: 1433
Registered: December 2006

Ultimate Contributor

Thanks for your answer.

luzr wrote on Mon, 19 January 2009 04:14

Well, I have to admit I am not using parameters mode too much recently; usually it buys you nothing.

I haven't check how SqlExp with explicit params works, but using parameters with SQL is very important. If you aren't using parameters, then server has to parse your SQL all the time. And very often parsing (and creating an execution plan) is more expensive than executing itself.

Quote:

In any case, maybe you can try inverse conversion - from SetParam to SqlExp....

Actually, I'm planing to move from SetParam to my own database code as soon as I will be able to integrate it into TheIDE build system, which is unfortunately very hard to use in workspace-like way.

Regards,
Novo

Report message to a moderator

[Message index]

		OleDB + parameters = problem By: Novo on Sat, 17 January 2009 18:16
		Re: OleDB + parameters = problem By: mirek on Mon, 19 January 2009 10:14
		Re: OleDB + parameters = problem By: Novo on Tue, 20 January 2009 23:34
		Re: OleDB + parameters = problem By: mirek on Wed, 21 January 2009 14:14
		Re: OleDB + parameters = problem By: mirek on Wed, 21 January 2009 14:22
		Re: OleDB + parameters = problem By: Novo on Fri, 23 January 2009 05:48
		Re: OleDB + parameters = problem By: Novo on Fri, 23 January 2009 06:03
		Re: OleDB + parameters = problem By: mirek on Fri, 23 January 2009 11:52
		Re: OleDB + parameters = problem By: mirek on Fri, 23 January 2009 11:59
		Re: OleDB + parameters = problem By: Novo on Sat, 24 January 2009 17:58
		Re: OleDB + parameters = problem By: mirek on Sat, 24 January 2009 20:19
		Re: OleDB + parameters = problem By: Novo on Sun, 25 January 2009 04:44
		Re: OleDB + parameters = problem By: Novo on Fri, 23 January 2009 05:55
		Re: OleDB + parameters = problem By: mirek on Fri, 23 January 2009 11:36

Previous Topic:	How to use Sql * Update
Next Topic:	Conditional jump or move depends on uninitialised value(s)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Sep 02 23:44:44 GMT+2 2026

Total time taken to generate the page: 0.00836 seconds