Varying elasped times in parse

Any clue why a sql statement that is identical in structure, yet inserting different values in a dynamic sql environment, would have such radically different elapsed times on the parse? This happens when a single client performs 10000 of these inserts - about 40 of them account for 20% of the elapsed time on the test.

Thanks for any insight, Jon.

insert into CpUser (userID, description, changePWFrequency, pwGenTime, firstName, enabled, login, middleName, pwHash, changePWNextLogon, lastName)
values (5497576674095, 'foo9005', 1, 'foo', 'Craig', 1, 'vos9005', 'A.', 'foo', 1, 'xxxxx')

call count cpu elapsed
------- ------ -------- ----------

Parse 1 0.02 0.53
Execute 1 0.00 0.00
Fetch 1 0.00 0.00
------- ------ -------- ----------

total 3 0.02 0.53

Misses in library cache during parse: 1

insert into CpUser (userID, description, changePWFrequency, pwGenTime, firstName, enabled, login, middleName, pwHash, changePWNextLogon, lastName)
values (5497576674972, 'foo9882', 1, 'foo', 'Craig', 1, 'vos9882', 'A.', 'foo', 1, 'xxxxx')

call count cpu elapsed
------- ------ -------- ----------

Parse 1 0.02 0.02
Execute 1 0.00 0.00
Fetch 0 0.00 0.00
------- ------ -------- ----------

total 2 0.02 0.02

Misses in library cache during parse: 1

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 05 1999 - 18:46:11 CDT