db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ali Demir <dem...@yahoo.com>
Subject Re: Database creation slow using create=true - any advice?
Date Mon, 14 Feb 2005 17:16:47 GMT
How about in a worker thread you maintain a pool of 5-10 databases and 
assign from this pool as the user clicks? The worker thread can try to 
maintain 10 available databases at all times, and if the user clicks so 
fast that all 10 are used before the 11th is created, then the user waits...

At 03:17 AM 2/14/2005, you wrote:
>I have a tree structure in a GUI that results in a new database being created
>and loaded with records when the user clicks on certain nodes.
>Currently however, when the user clicks on the node, the bottleneck is 
>when the
>'create=true' call is made. This creation seems to be taking ~20secs on my
>machine, whereas if the database already exists, it takes <1sec to load and
>query the database.
>Anybody got any ideas how I can optimize this? I haven't found anything as 
>- Darryl

View raw message