Hi,

> This feature will definitely be really useful to solve a lot of real
> life complex problems

I'm sorry, I have added this to the list of features that I _don't_
want to implement: "In prepared statements, identifier names (table
names and so on) can not be parameterized. Adding such a feature would
complicate the souce code without providing reasonable speedup, and
would slow down regular prepared statements."

> With Prepared Statements, after doing about 100+ runs, the average
> processing was - 7000 inserts /sec
> With Statements, after doing about 100+ runs, the average processing
> was - 4500 inserts /sec
> There is a gain of almost 60% by using prepared statements.

I don't think the speedup is related to using a prepared statement.
Let's find out what the problem is! Could you provide a simple,
standalone test case? Please see
http://h2database.com/html/build.html#support

Regards,
Thomas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to