how to make ez run faster?

Next topic

Author	Message
Vytautas Germanavičius	Thursday 05 October 2006 10:26:31 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}
Claudia Kosny	Friday 06 October 2006 4:57:19 am Hello vytis Please give us a bit more information: - Version of EZ - Version of PostgreSQL - the precise query that takes so long - the listing with the timing points and time accumulators and maybe other interesting debug output And please don't post the same question twice. Greetings from Luxembourg Claudia

Author

Message

Thursday 05 October 2006 10:26:31 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}

Claudia Kosny

Friday 06 October 2006 4:57:19 am

Hello vytis

Please give us a bit more information:
- Version of EZ
- Version of PostgreSQL
- the precise query that takes so long
- the listing with the timing points and time accumulators and maybe other interesting debug output

And please don't post the same question twice.

Greetings from Luxembourg

Claudia