db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ray Gala" <rg...@mdte.com.au>
Subject Derby 10.6 upgrade problem
Date Tue, 08 Jun 2010 06:57:33 GMT
Hi,

We are trying to upgrade our existing Derby DB from version 10.2.2 to the latest build 10.6.
Problem is that our database contains thousands of tables with the names starting from "SURVEY_xxxxx"
where xxxxx can be any integer from 1 to 99999. Upgrade fails on this tables to the point
that one cannot access any of them, because apparently it takes a very long time to open them.

We staged a test in order to see how database handles creation of thousands of similarly named
tables.

Below we will try to describe how the test was conducted.

 

Process

·         Create a new blank database in 10.6

 

In a loop from 1 to 10000 { although I only managed to get to 1510 over night}

·         Created a program that creates a table called SURVEY_X

·          Inserts ½ hour interval data from the range  2006-08-03 15:00:00 to 2009-01-15
00:00:00. 40,000 records.

 

And this process repeats.

 

Results

·         At the start (10:00 pm) a single cycle of create and insert was taking 2 seconds
- i.e  Creation of SURVEY_1

·         In the morning 7:00am it had only got to 1510 table and insert creations, and was
taking  2 minutes - i.e Creation of SURVEY_1510
 

If I change the program (and use it on this database with the current 1510 tables in it) to
create a table called T_SURVEY_X then it goes back to 2 seconds, although I suspect that if
I left it running and we had 1500 tables called T_SURVEY_X we would have the same problem.

The symptom is also present in SQLWorkbench/J where it takes 2 seconds to see table T_SURVEY_0
but 45 seconds to see SURVEY_1510 and even after it presents the data it still seems to lock
up etc. 

So this explains why with 6000 tables that we seem to get no response at all.  As you can
see from the enclosed log performance starts really degrading after a 1000 tables.

Question: Is this a known issue, and can this be fixed?
 
Thanks a lot for your response.

Ray


-------------------------------------------------------
Ray Gala
rg082@mdte.com.au
Metering Dynamics
Australia
 

 




Mime
View raw message