db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Derby Char Column Type Versus VarChar
Date Tue, 06 Apr 2010 13:45:52 GMT
 > My question is any reason why the database responding (select /inserts) becomes slower
as the database usage becomes more.

If you can observe the performance impact in a reliable
and reproducible fashion, you could try:

1) Set up the fast-responding behavior
2) Capture runtime statistics from several well-performing statements
3) Set up the poor-performing behavior
4) Capture runtime statistics from the same statements

Then we could compare the output and look at the differences
to understand the performance degradation in more detail.



View raw message