| Subject | Re: [firebird-support] Configuring Firebird for high transaction through put |
|---|---|
| Author | Germán Balbi |
| Post date | 2014-10-29T13:19:34Z |
Run stadistic for database
- Look for index in de big tables. Look for Depth > 2. In this case up Page size one step, and run database statistical.
- Look memory at each
step
Good luck
Germán
El Viernes, 12 de septiembre, 2014 15:37:38, "Alexey Kovyazin ak@... [firebird-support]" <firebird-support@yahoogroups.com> escribió:
Hi Russel,
Good starting point could be our optimized configuration files:
http://ib-aid.com/en/optimized-firebird-configuration/
Regards,
Alexey Kovyazin
IBSurgeon
Good starting point could be our optimized configuration files:
http://ib-aid.com/en/optimized-firebird-configuration/
Regards,
Alexey Kovyazin
IBSurgeon
What type of access (read vs. write mix) are you expecting? Mainly write
What mix of small vs. large queries are you expecting? the queries are based on single order ids (primary keys) and about 4 tables involved
How many simultaneous connections are you expecting? that's the big question we are looking at a range of 1400 - 13000 orders per hour
What page cache number and page size have you tested with? page buffers: 2048; page size: 4096
What type of HDD config and how much RAM will the server have? all on virtual. 2 HDD and 4GB ram - can increase to 16GB
What OS? Windows server 2012
Russell Weetch
SMXi – the heartbeat of your business
Systematic Marketing, 429-433 Pinner Road, Harrow HA1 4HN, United KingdomSMX, SMXi, Masque® and Masque Arts are trading names and trade marks of Systematic Marketing LtdRegistration No. 2472380 England / VAT 541 2972 49This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify me immediately. If you are not the intended recipient of this email, you should not copy it for any purpose, or disclose its contents to any other person.
On 11 September 2014 16:35, 'Leyne, Sean' Sean@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
> We are having to gear up one of our web apps for a potential spike in access
> next month and have been running some load testing. Overall it seems not
> to bad but the database is a bit of a bottleneck or so it seems.
>
> Without turning off forced rights what else should we look at? We have
> increased core utilisation. Does page size have an impact? Any ideas would
> be welcomed. Are there any documents anywhere that cover this?
What type of access (read vs. write mix) are you expecting?
What mix of small vs. large queries are you expecting?
How many simultaneous connections are you expecting?
What page cache number and page size have you tested with?
What type of HDD config and how much RAM will the server have?
What OS?
Sean
