Home » U++ Library support » U++ SQL » OleDB + parameters = problem
Re: OleDB + parameters = problem [message #19812 is a reply to message #19806] |
Fri, 23 January 2009 11:52   |
 |
mirek
Messages: 14261 Registered: November 2005
|
Ultimate Member |
|
|
OK, you have been proved right w.r.t. prepared statements and speed, at least with MSSQL:
void Benchmark()
{
Sql sql;
sql * Select(ID).From(SUBJECT);
Vector<int> id;
while(sql.Fetch())
id.Add(sql[0]);
for(int i = 0; i < id.GetCount(); i++) {
RTIMING("Unprepared");
sql % Select(TEXT).From(SUBJECT_ATTR).Where(ATTR == "NAME" && SUBJECT_ID == id[i]);
}
sql.SetStatement("select TEXT from SUBJECT_ATTR where ATTR = ? and SUBJECT_ID = ?");
for(int i = 0; i < id.GetCount(); i++) {
RTIMING("Prepared");
sql.Run("NAME", id[i]);
sql.Fetch();
}
}
TIMING Prepared : 79.99 ms - 273.94 us (80.00 ms / 292 ), min: 0.00 ns, max: 1.00 ms, nesting: 1 - 292
TIMING Unprepared : 483.99 ms - 1.66 ms (484.00 ms / 292 ), min: 0.00 ns, max: 15.00 ms, nesting: 1 - 292
Well, SqlExp cache will be fun Thanks for makeing me aware about this.
Mirek
|
|
|
 |
|
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
|
Goto Forum:
Current Time: Wed Jun 25 14:05:00 CEST 2025
Total time taken to generate the page: 0.03621 seconds
|