Hi,
thank you for reply, answering to your questions
. Did you run the sql directly from command line or via a db client?
This is an example query in the bootstrap
$db->query("SET NAMES 'utf8'");
but also all the other queries are slow and make not difference if they are
inside a controller or in an action helper.
I use pdo_mysql as adapter.
. How many records are there in the main table?
Not to many, but also if they are 10 is slow
. Are there any index fields defined?
Some table have primary key, some others not, but query one but the other is
slow the same
. Any joined table?
I have join queries, but also simple query are slow
How do you determine that the sql is slow and takes 6-8seconds
I have to say that I am not sure that queries are slow.
The simpler test I've done is to put the line of code "die('test');" before and
after the db call.
If it is before the output is generated in an instant, if it is after is slow.
BUT using ZFDebug plugin it says that all the queries are really fast ( 0.22 ms
for example in front of a 10000.00 and more ms of page loading time )
Profiler is active?
Active or not active nothing change
And also I have Metadata cache ENABLED ( keep it disabled is the same )
Here it is a log with ZFDebug
Overall Time
default
index
index
Avg: 5900.1 ms / 1 requests
Min: 5900.1 ms
Max: 5900.1 ms
with 2 query ( 0.16 ms and 0.07 ms )
The version of Zend Framework that I'm using is 1.10.2.
I can hypothesize a problem with Zend_Db component in the environment I
actually am.
What's your advices?
Thank You!
Sergio
--------------------
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.
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.
>
>
>
> ________________________________
> Oltre 20 giochi per Messenger. Provali subito!
>
_________________________________________________________________
Scatta, ritocca e condividi le tue foto online. Gratis per te
http://www.windowslive.it/foto.aspx
