[firebird-support] RE: Why is this setup not working?
Hey Mark. Thanks for your reply. The firebird DB is running SuperClassic. The config kan be found on pastebin http://pastebin.com/ZzxL4xVc http://pastebin.com/ZzxL4xVc
[firebird-support] RE: Why is this setup not working?
Hi Alexey. Thanks for your respons. I acknowledge your thoughts. I would like to address the issue of scale-ability. What are our options of scaling the environments. For now we have sharded the database into two separate servers(on psychical hardware). That helped for a while but bow the connections is killing us. We haven't been able to find any connection pool software that supports firebird(Anyone know of any?). /Ronnie
Re: [firebird-support] RE: Why is this setup not working?
Hi, There are some things in the config which could be tuned, but not many - I would increase size of lock table to 10Mb and number of page buffers to 512 pages. But in general it looks like typical problems are not in place here, i.e. your problem is not obvious and it requires professional support, with database statistics investigation, ongoing transaction's markers monitoring, queries audit, locks analysis, etc. Regards, Alexey Kovyazin Hey Mark. Thanks for your reply. The firebird DB is running SuperClassic. The config kan be found on pastebin http://pastebin.com/ZzxL4xVc