|[Ticket #287] [firebird-support] Slow Database
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.
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]