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 #19806 is a reply to message #19794]

Fri, 23 January 2009 05:48

Novo
Messages: 1431
Registered: December 2006

Ultimate Contributor

luzr wrote on Wed, 21 January 2009 08:22

Speaking about it, it would be really nice if you can provide the benchmark.

In fact, current SqlExp should be possible to expand to support parameters as well, with automatic cache of preparsed statements.

Just show me it has any benefit Smile

Mirek

http://www.ultimatepp.org/forum/index.php?t=msg&goto=115 05&#msg_11541

Try to compare time of insertion of 100000 records. I believe I included drivers for SQLITE and Firebird, which is not supported by U++. I can try to build drivers for other databases and develop more tests. But that will take some time.

From my personal experience I know that using parameters with ORACLE speeds up database operations approximately three times.
Just try to monitor SQL-cache when inserting millions of records not using parameters. Actually, that would be not absolutely correct test because ORACLE is able to auto-detect parameters-capable SQL and transform SQL before executing it.

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 Apr 29 05:39:57 GMT+2 2026

Total time taken to generate the page: 0.00463 seconds