[firebird-support] RE: Why is this setup not working?

[talker3333]

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

Re: [firebird-support] RE: Why is this setup not working?

[Alexey Kovyazin]

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

[firebird-support] RE: Why is this setup not working?

[talker3333]

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