db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: pagesize for a given table
Date Tue, 02 Feb 2010 15:53:17 GMT
David Parker wrote:
> slowdowns that we have traced to this insert - a single insert taking several seconds

That feels more like a locking issue than an I/O issue, to me.

Perhaps you have some sort of rarely-run query which, when it runs,
scans and processes the entire table, thus locking the table and
preventing any insert into the table.

Just a guess.



View raw message