Here are the results of more testing. I difference between these and the last one
are, Indexed the primary keys in the database -this resulted in about a 50% increase
in performance, I changed the instance cache to random passivation and commit option
to option c (small increase in performance), and the mlet console logging filter set
for only Error mesages. And I am using the Sprint 2000 MSSQL JDBC driver from
Inet(evaluation version)(small increase in performance) and I moved all the jndi
lookups outside of the tests.
(each set performs creates on 4 different beans for a total of 280 beans(rows) created)
time to create customer set : 0 - 6328ms -- 22ms/create
time to create customer set : 1 - 5703ms -- 20ms/create
time to create customer set : 2 - 5578ms -- 19ms/create
time to create customer set : 3 - 5578ms -- 19ms/create
time to create customer set : 4 - 5500ms -- 19ms/create
time to create customer set : 5 - 7125ms -- 25ms/create
time to create customer set : 6 - 5422ms -- 19ms/create
time to create customer set : 7 - 5531ms -- 19ms/create
time to create customer set : 8 - 5375ms -- 19ms/create
time to create customer set : 9 - 5594ms -- 19ms/create
time to create customer set : 10 - 5625ms -- 20ms/create
...
...
time to create customer set : 40 - 5375ms -- 19ms/create
time to create customer set : 41 - 5562ms -- 19ms/create
time to create customer set : 42 - 5469ms -- 19ms/create
time to create customer set : 43 - 5516ms -- 19ms/create
time to create customer set : 44 - 5359ms -- 19ms/create
time to create customer set : 45 - 5563ms -- 19ms/create
time to create customer set : 46 - 5578ms -- 19ms/create
time to create customer set : 47 - 5375ms -- 19ms/create
time to create customer set : 48 - 7859ms -- 28ms/create
time to create customer set : 49 - 5719ms -- 20ms/create
brandon
[EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
