On Wed, Mar 24, 2010 at 12:01 PM, scs <[email protected]> wrote: > Hi, > Could you write the sql sentence here? > How do you determine that the sql is slow and takes 6-8seconds? > Profiler is active? > Then, > . Did you run the sql directly from command line or via a db client? > . How many records are there in the main table? > . Are there any index fields defined? > . Any joined table? > . problem in join structure? > etc.
You really need to look at it through a profiler (e.g. Xdebug). Zend_Db may not be the fastest kid on the block, but I find it hard to believe that you waste those 6 seconds in PHP code. ;-) It could be something as simple as slow DNS resolution or who knows that. Till > > On Wed, Mar 24, 2010 at 12:39 PM, Sergio Rinaudo > <[email protected]> wrote: >> Hi everybody, >> I've started a new application project using Zend Framework, unfortunatelly >> I am experiencing a really slow database query ( 6~8 sec for very simple >> queries ). >> I'm not mantaining the server, the only thing I know that is unix. >> >> Any advice in what should I have to look or configure? >> Thanks >> >> Sergio R. >>
