[firebird-support] Dividing one column by another

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

I am trying to divide one column in table A by another in table B, but it
just gives me null values. The query is

SELECT A.AMOUNT, B.VALUE, A.AMOUNT/B.VALUE
FROM TABLE1 A
JOIN TABLE2 B ON A.URN = B.URN

any ideas gratefully received.

Russell

[firebird-support] Firebird 3 and Encryption

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

Hi

Not sure whether I have been looking in the right place, but is data
encryption included in Firebird 3?

Also, any estimate of when the release candidate will be available?

Thanks

Russell
SMXi

Re: [firebird-support] Re: Firebird 3 and Encryption

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

Many thanks for the update


*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 2 November 2015 at 16:25, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support]  wrote:

>
>
> 02.11.2015 19:21, Russell Weetch russ...@smxi.com wrote:
> >
> > Not sure whether I have been looking in the right place, but is data
> > encryption included in Firebird 3?
>
> Technology is built in, but the encryption plugin should be developed by
> you or someone else. Firebird itself does not provide any default
> implementation [yet].
>
> > Also, any estimate of when the release candidate will be available?
>
> This week.
>
> Dmitry
>
> 
>

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] http://uk.linkedin.com/in/russellweetch/
https://twitter.com/smxsoftware
http://www.facebook.com/SystematicMarketing
http://smxi.com/blogs/russell.weetch
https://plus.google.com/+russellweetch

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