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

2014-09-11 Thread russ...@smxi.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

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

2014-09-11 Thread '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

[firebird-support] Proper way to configure Firebird startup on FreeBSD 10

2014-09-11 Thread stevef...@yahoo.com [firebird-support]
I've successfully installed Firebird on FreeBSD 10 but can't seem to find documentation on the proper way to configure it to run at system startup. Somewhere on the www, I found that you should add the following line to /etc/rc.conf: firebird_enable=YES I did this and it seems to

RE: [firebird-support] Help With External Table Issue

2014-09-11 Thread 'Edward Mendez' emendez...@nc.rr.com [firebird-support]
Hello All, We have a Firebird 2.1.4 running on CentOS 5.5 I am having a problem trying to insert data into an External Table and then read it back. Here is out output from fbsvcmgr; fbsvcmgr service_mgr -user sysdba -password masterke -info_server_version -info_implementation

RE: [firebird-support] Help With External Table Issue

2014-09-11 Thread 'Edward Mendez' emendez...@nc.rr.com [firebird-support]
Hi All, I think I found out why I am having the problem. I found release notes on Firebird 2.5 and saw this following… Large External Table Support Enabled Vlad Khorsun Previous Firebird versions used 32-bit I/O when working with external tables, limiting the size of the external

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

2014-09-11 Thread 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