Subject [Ticket #287] [firebird-support] Slow Database
Author Desarrollo
This is a notification from the Help Desk.

On Mar 07, 2014 @ 03:30 pm, ch.kaufmann@... wrote:

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.

cu Christian

This is an automated response. Your issue has been noted. We'll be in touch soon.

Please reply to this email or visit the URL below with any additional details.


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