| Subject | Re: [firebird-support] Slow join with mon$ tables |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2009-02-20T13:16:14Z |
Douglas Tosi wrote:
everything worked okay.
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?
It would be interesting to compare your case in v2.1.2 vs v2.5, as so
far I suspect that it's temporary blobs (MON$SQL_TEXT column) that
wastes so much memory, and it has been improved in v2.5.
As for the join performance, I have to admit it's unlikely you can
improve it currently. Something to think about in future versions.
Dmitry
>Weird. It was tested with 800 connections a couple of months ago and
> 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.
everything worked okay.
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?
It would be interesting to compare your case in v2.1.2 vs v2.5, as so
far I suspect that it's temporary blobs (MON$SQL_TEXT column) that
wastes so much memory, and it has been improved in v2.5.
As for the join performance, I have to admit it's unlikely you can
improve it currently. Something to think about in future versions.
Dmitry