Tools for building a db init script, perhaps besides Commons Jelly SQL
- From: davidmichaelkarr@xxxxxxxxx
- Date: 24 Dec 2006 20:57:08 -0800
I've written a dbinit script using Commons Jelly SQL. It works, but
it's dog slow. I can't get any response from the normal channels to
questions about how to optimize it. My script creates 10-15 tables and
inserts several hundred rows. I monitor it's progress while it's
running from a SQL browser (SQuirreL), and it seems like it inserts one
row a second. I tried to set it up so that all the inserts are in a
single transaction, but either I didn't do that correctly, or it makes
no difference.
I could use some advice on whether I could get my Jelly script working
better, but I'd also be willing to look at other tools or strategies
for building a db init script. Jelly is pretty convenient, as I can
set variables for commonly used values, and write reusable methods that
I can call multiple times.
.
- Prev by Date: CachedRowSet and double column types
- Next by Date: mysql-connector-java-5.0.4-bin-g.jar not connecting
- Previous by thread: CachedRowSet and double column types
- Next by thread: mysql-connector-java-5.0.4-bin-g.jar not connecting
- Index(es):
Relevant Pages
|
|
