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]