Find solution
how can I integrate slim framework in cakephp?

Why should I use PEAR::DB when I can use model classes implemented in a framework like Zend, CakePHP or Yii?

  • These days many different frameworks are providing comfortable database abstraction layer, for-example cakephp provides find(), so why should I still consider using PEAR::DB. CakePHP Find reference:http://book.cakephp.org/view/1018/find Is PEAR::DB better in terms of performance as compared to model classes implemented by frameworks?

  • Answer:

    <msaads> I am working on a very cumbersome website that is created using a framework. It has response time issues, plus there are many big queries being executed. Sphinx is used, but it seems not sufficient. <tom[]> if the problem is big queries, the abstraction layer win't make any difference <msaads> I was thinking the same <tom[]> the performance improvements you need will come from improving the queries, restructuring the schema, using indexes correctly <tom[]> the normal DB stuff <tom[]> or buy faster hardware <msaads> Thanks tom for the tips <tom[]> $500 for SSD can make a huge difference <tom[]> going back to the stone ages with PEAR won't help <tom[]> you are welcome!

Muhammad Saad Siddiqui at Quora Visit the source

Was this solution helpful to you?

Other answers

Some frameworks are known to have performance issues, but usually what slows down websites of a certain size is the database. In 99% of all cases, that's because of badly (or according to IT theory) designed database schemes. Faster hardware can solve those issues temporarily, but you don't want to go down that path. Optimize first, then upgrade your hardware if you must, or even better: redesign your system for scalability (RDS etc.). Considering issues regarding many frameworks database components: Make sure you properly utilize all available caching options for metadata and read-only data to save a lot of processing time. PEAR components in general have a high quality, but they are also often outdated in terms of PHP features. For the sake of compatibility, most PEAR components are stuck in the 5.3 age, which might or might not be an issue for you.

Philipp C. Gérard

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.