search

efmarshall / h2database

Automatically exported from code.google.com/p/h2database
0 stars 0 forks source link

Triggers: Initialize PreparedStatements once per transaction #511

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
According to the discussion at 
https://groups.google.com/d/msg/h2-database/Sb3T1aVwoCE/PGrlISXrK7IJ 
initializing PreparedStatements ahead of time (instead of inside 
Trigger.fire()) leads to noticeable performance benefits.

Please consider this alternate Trigger interface which improves the API aside 
from the aforementioned performance benefits.

Original issue reported on code.google.com by cow...@bbs.darktech.org on 3 Oct 2013 at 3:18

GoogleCodeExporter commented 9 years ago

Original comment by noelgrandin on 9 Oct 2013 at 7:53

GoogleCodeExporter commented 9 years ago 
Attached proposed interface and testcase demonstrating performance benefit of 
initializing PreparedStatement once per transaction (as opposed to once per 
fire()).

Original comment by cow...@bbs.darktech.org on 9 Oct 2013 at 7:34

Attachments: