Subject | Re[2]: [Firebird-general] Zend server/php caching results |
---|---|
Author | Sergey Mereutsa |
Post date | 2014-10-22T12:59:07Z |
Hello Lester,
I found that sometimes directly moving DB from MySQL to Firebird will
NOT improve the performance. I`v seen a lot of projects relying on
fast select count() for the number of records.
P.S. If you wish - you can use this
https://github.com/Greendq/PHP-FBDBC
I`ll update the code after the conference - Redis cache class in the
current version will not cache the empty resultset, but it should.
--
Best regards,
Sergey mailto:serj@...
Wednesday, October 22, 2014, 3:12:04 PM, you wrote:
LCllcuFg> On 18/09/14 22:14, wobbleian@... [Firebird-general] wrote:
LCllcuFg> Been moving a number of MySQL only applications to Firebird and finding
LCllcuFg> much better performance. On nginx these days which improves things
LCllcuFg> again, but eacceelerator has not been keeping up and I'm not finding the
LCllcuFg> 'built in' caching of pages is as good. Growing number of sites slowly
LCllcuFg> moving off old ersions of PHP onto a nice
LCllcuFg> Firebird/nginx/php/linux stack.
I found that sometimes directly moving DB from MySQL to Firebird will
NOT improve the performance. I`v seen a lot of projects relying on
fast select count() for the number of records.
P.S. If you wish - you can use this
https://github.com/Greendq/PHP-FBDBC
I`ll update the code after the conference - Redis cache class in the
current version will not cache the empty resultset, but it should.
--
Best regards,
Sergey mailto:serj@...
Wednesday, October 22, 2014, 3:12:04 PM, you wrote:
LCllcuFg> On 18/09/14 22:14, wobbleian@... [Firebird-general] wrote:
>> 4. I've been "happy" with php for 14 years, have I been mad and shouldLCllcuFg> Ditto here.
>> we have been using Zend Server all along? [I respect your opinions more
>> than any other forum even though it's nothing to do with firebird!]
LCllcuFg> Been moving a number of MySQL only applications to Firebird and finding
LCllcuFg> much better performance. On nginx these days which improves things
LCllcuFg> again, but eacceelerator has not been keeping up and I'm not finding the
LCllcuFg> 'built in' caching of pages is as good. Growing number of sites slowly
LCllcuFg> moving off old ersions of PHP onto a nice
LCllcuFg> Firebird/nginx/php/linux stack.