db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: anybody know why the derby alway appear "requesting a lock"
Date Sat, 08 Sep 2007 15:56:58 GMT
Templexp Tan skrev:
> it is under the c/s mode. why the program running a very frenquent 
> inserting operation , it comes "requesting a lock"
> and the speed compare to oracle is extramly slow. it is about only 
> 10,000 records.
>
> the DERBY version:
>
> 10.3.1.4 <http://10.3.1.4/>
>
>
>
Hello,

Can you please give a little more information about the load you see 
problems with in Derby?

For instance;
 * What kind of queries are being executed concurrently against the table?
 * How many concurrent users/connections?
 * What is the isolation level used?
 * Do you run with auto-commit on or off?
 * Are you using a PreparedStatement to execute your inserts?

Also, what do you mean with "requesting a lock"? Do you get an error 
message in your client or the derby.log file?
Or does the server appear to be idle?


thanks,
-- 
Kristian

Mime
View raw message