Re: [firebird-support] Configuring Firebird for high transaction through put

[Thomas Steinmaurer t...@iblogmanager.com [firebird-support]]

> 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.

 >2 is quite conservative these days with the available hardware 
resources and even with a 16K page size you may reach that threshold 
with indexes on moderate sized tables rather quickly. Everything <=3 is 
just fine.


-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

Re: [firebird-support] Configuring Firebird for high transaction through put

[Germán Balbi bal...@yahoo.com [firebird-support]]

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 a...@ib-aid.com 
[firebird-support]"  escribió:
 


  
Hi Russel,

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
>T: +44 (0)20 7100 6010  M:+44 (0)7879 816084  W:http://smxi.com  
>E:russ...@smxi.com  
> 
>Systematic Marketing, 429-433 Pinner Road, Harrow  HA1 4HN, United Kingdom
>SMX, SMXi, Masque® and Masque Arts are trading names and trade marks of 
>Systematic Marketing Ltd   
>Registration No. 2472380 England / VAT 541 2972 49
>This 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' s...@broadviewsoftware.com 
>[firebird-support]  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 
>>
>>
>

Re: [firebird-support] Configuring Firebird for high transaction through put

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

Hi Russel,

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/

*T: *+44 (0)20 7100 6010 *M:*+44 (0)7879 816084 *W:*http://smxi.com 
 *E:*russ...@smxi.com 


Linked In  
 
 
 



Systematic Marketing, 429-433 Pinner Road, Harrow HA1 4HN, United Kingdom

SMX, SMXi, Masque® and Masque Arts are trading names and trade marks 
of Systematic Marketing Ltd


Registration No. 2472380 England / VAT 541 2972 49

This 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' s...@broadviewsoftware.com 
[firebird-support] > 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

Re: [firebird-support] Configuring Firebird for high transaction through put

[Russell Weetch russ...@smxi.com [firebird-support]]

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*

*T: *+44 (0)20 7100 6010  *M:* +44 (0)7879 816084  *W:* http://smxi.com
*E:* russ...@smxi.com

[image: Linked In] 





Systematic Marketing, 429-433 Pinner Road, Harrow  HA1 4HN, United Kingdom

SMX, SMXi, Masque® and Masque Arts are trading names and trade marks of
Systematic Marketing Ltd

Registration No. 2472380 England / VAT 541 2972 49

This 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' s...@broadviewsoftware.com
[firebird-support]  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
>
>  
>

RE: [firebird-support] Configuring Firebird for high transaction through put

['Leyne, Sean' s...@broadviewsoftware.com [firebird-support]]

> 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