U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

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

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

Return to the default flat view

Create a new topic

Submit Reply

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

Tue, 20 January 2009 23:34

Novo is currently offline

Novo
Messages: 1430
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

Send a private message to this user

[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) ] [

] [

PDF

]

Current Time: Wed Jun 25 14:23:08 CEST 2025

Total time taken to generate the page: 0.05368 seconds