On Fri, Feb 20, 2009 at 10:16 AM, Dmitry Yemanov
<dimitr@...> wrote:

> Douglas Tosi wrote:
>> But 2.5 seems broken (Firebird-2.5.0.22983-0_x64).
>> mon$attachments display only the current_connection. I cannot see the
>> other 200 attachments.
>> Every attachment was made using sysdba. I should be able to view them.
>
> Weird. It was tested with 800 connections a couple of months ago and
> everything worked okay.

Yes, I remember that too. I'll redo my tests using the old 2.5 alpha as well.

> Can you see other connections if the total load is mush smaller, e.g.
> just two or three connections? Any difference between SS and CS?

I'll test and report back.

> As for the join performance, I have to admit it's unlikely you can
> improve it currently. Something to think about in future versions.

Not a problem. I just wanted a confirmation that there was nothing I
could do at sql level.
I'll join them in the client.

Regards,
--
Douglas Tosi
www.sinatica.com