Hello,

>
> I have a website with PHP and a Firebird database. It looks like the
> Firebird database becomes very slow and I don't know, how to find
> where and why.
>
> My database is 15GB, the biggest table has about 30 million records.
>
> Right now I try to create the statistics, but it takes for ever. At
> the same time I try to monitor the database with the Sinatica tool.
> OAT and Next transaction are close, no GC pending.
>
> What I see is a lot warnings like "invalid char set", but I think,
> this has nothing to do with performance.
>
> I'm also not aware of any statement not using indexes or so.
>
> What can I do? How do I find the bottle necks? It must be in Firebird,
> but I don't know, what I do wrong.
>

You can try our [commercial tool] FBScanner
(http://ib-aid.com/products/firebird_interbase/monitoring/FBScanner).


Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)



[Non-text portions of this message have been removed]