Path

ez projects / ezobjectstatesfilter / forum / general / little improvement to gener...

little improvement to generated sql

You need to be logged in to post messages in the forums. New users may register here.

Gaetano Giunta

Member since:
09 January 2008

Posts: 241

Sunday 26 April 2009 6:43:11 pm

I do not think it is necessary to add N times the contentobjectstables tables to the sql list, once should be enough (at least it works when using OR conditions).
Might make for a slightly faster code...

Principal Consultant International Business
Member of the Community Project Board
Up

Damien Pobel

Member since:
09 January 2008

Posts: 40

Wednesday 29 April 2009 10:06:12 am

Hi Gaetano,

Thanks for your feedback.
You're right when the conditional operator is OR only one join with ezcobj_state is required.

Cheers

Damien
Planet eZ Publish.fr : http://www.planet-ezpublish.fr
Certification : http://auth.ez.no/certification/verify/372448
Publications about eZ Publish : http://pwet.fr/tags/keywords/weblog/ez_publish
Up

You need to be logged in to post messages in the forums. New users may register here.