Subject | Re: Long timeouts on connect / exec query |
---|---|
Author | hvlad |
Post date | 2010-06-30T10:08:27Z |
--- In firebird-support@yahoogroups.com, Christian Kaufmann
...
As you already use FB 2.5 - try its new trace feature and log all long-running queries to analyze them.
Regards,
Vlad
...
> I think, it's not a PHP problem but a problem of my configuration of myLook at database statistics at time when response times is big and find out if auto-sweep is the reason.
> Firebird server.
>
> I really like Firebird, but to find solutions to such problems here is
> rather difficult for me. It's more "fishing in the dark" right now.
>
> All I know, that in general my application / database runs fine, but at
> some points, repsonse times to request are just too long. And here I'm
> stuck, I don't have a good plan to identify the real problem and to
> solve it.
As you already use FB 2.5 - try its new trace feature and log all long-running queries to analyze them.
Regards,
Vlad