Re: [fw-db] Zend_Db::fetchAll() unacceptably slow

Hello,

can you make a tracedump or a kcachegrind output using xdebug
for just your use-case?

Otherwise its impossible to tell what causes this.

greetings,
Benjamin

On Wed, 30 Sep 2009 05:03:22 -0700 (PDT), umpirsky <umpirsky@gmail.com>
wrote:
> Hi.
>
> I have mysql table:
>
> CREATE TABLE `brand` (
> `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Car brand ID',
> `title` varchar(32) default NULL COMMENT 'Car brand title',
> PRIMARY KEY (`id`)
> ) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8 CHECKSUM=1
> DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC
>
> with 93 records inserted.
>
> I'm using Zend_Db with MYSQLI adapter. When I execute fetchAll(null,
> 'title') it takes 15 seconds to complete fetch!!! This is terrible slow,
> isn't it?
>
> Profiler says:
>
> 0.00114 SELECT `brand`.* FROM `brand` ORDER BY `title` ASC
>
> which is ok and blazing fast.
>
> Looks like fetchAll is wasting time somewhere. This is not unacceptable.
>
> Any idea?