| Subject | Re: [firebird-php] Firebird 1.5.6 + PHP 5.4.20 + i7 Haswell processor Linux 64 bit |
|---|---|
| Author | Sakhile Njoko |
| Post date | 2014-06-16T09:27:12Z |
Thanks Masotti for trying to help. I ended up migrating to postgres. Everything is working well so far. It was the toughest decision because I truly love firebird but php support for firebird is quite poor. Unfortunately, php is critical in my applications.
On Wednesday, 4 June 2014, 19:13, "masotti masotti@... [firebird-php]" <firebird-php@yahoogroups.com> wrote:
Hi,
Il 04/06/2014 10:44, wildekonrad@... [firebird-php] ha scritto:
> d) when I start PC-2 PHP+Firebird (select from 4 databases) - performance is BAD, work all cores processor, each cores use 0-1,3%, total processor use under 8%,
Some more things to check, as you're running on a 64 bit OS.
Which distro are you using?
Firebird is 32 bit distribution software (1.5 AFAIR was not released in
64bit version) or have you recompiled on your host for 64 bit?
Same question for firebird client and php fb driver.
Which connection type are you using? Direct or TCP/IP?
If you are using direct connection from PHP 5.4, try instead TCP/IP
trough localhost:aliasname.
Did you check your application's same query, using instead isql-fb?
At the moment I've no more clues or suggestion...
MM