Re: Database creation slow using create=true - any advice?

[Ali Demir]

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...
Regards,
Ali

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 
yet.

- Darryl