Forums / Install & configuration / ez is too sow... simple query takes 4 sec.

ez is too sow... simple query takes 4 sec.

Author Message

Vytautas Germanavičius

Thursday 05 October 2006 10:28:06 pm

I wrote my extension for ez. It is very simple: rubn query select top 10 form table and fetch template to display results.
i tested query on pgMyAdmin - it takes 0.08s. But when i run extension, it takes 4.4s !(according debug info)
why???

{set-block scope=root variable=cache_ttl}0{/set-block}

Xavier Dutoit

Saturday 07 October 2006 8:00:20 am

Well, on the debug info, you have more explainations on where ez spends its time.

The template might be quite heavyweight...

X+

http://www.sydesy.com

Vytautas Germanavičius

Monday 09 October 2006 4:55:19 am

As i understand, this shows, that EZ does something 1.7 sec, before it starts my written module? Or initialization of module takes 1.7s?

Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory
Module start 'conferences' 0.0000 sec 1.7699 sec 12,894.0547KB 6,769.3438KB
Module end 'conferences' 1.7699 sec 0.7357 sec 19,663.3984KB 8,409.5156KB
End 2.5055 sec 28,072.9141KB 0.0078KB
Total runtime: 3.2523 sec

{set-block scope=root variable=cache_ttl}0{/set-block}

Xavier Dutoit

Monday 09 October 2006 8:13:41 am

Hi,

That's the kind of numbers you have the first time you run the script if you haven't cached/compiled the templates.

Once it's been ran one everything is cached and it should be near 0.

Check your setting otherwise.

X+

http://www.sydesy.com