Login | Register
My pages Projects Community openCollabNet

Discussions > dev > [propel-dev] PostgreSQL Specific optimization in Criteria

propel
Discussion topic

Back to topic list

[propel-dev] PostgreSQL Specific optimization in Criteria

Reply

Author Cameron Brunner <cameron dot brunner at gmail dot com>
Full name Cameron Brunner <cameron dot brunner at gmail dot com>
Date 2009-04-25 21:29:38 PDT
Message Anyone object if we start adding db specific optimizations in? specifically this

instead of doing IN (val1,val2,val3etc) you do IN (SELECT
(ARRAY[val1,val2etc])[i] FROM generate_series(1,count($total in the
list)) i)

turned a query i was doing in postgres from taking 81secs to 650ms
since the query planner had more data it could use

--
Cameron Brunner

Want a better web browser?
http://www.spreadfir​efox.com/?q=affiliat​es&id=182780​&t=1

« Previous message in topic | 1 of 17 | Next message in topic »

Messages

Show all messages in topic

[propel-dev] PostgreSQL Specific optimization in Criteria Cameron Brunner <cameron dot brunner at gmail dot com> Cameron Brunner <cameron dot brunner at gmail dot com> 2009-04-25 21:29:38 PDT
     Re: [propel-dev] PostgreSQL Specific optimization in Criteria tony_bibbs Tony Bibbs 2009-04-27 07:30:44 PDT
         Re: [propel-dev] PostgreSQL Specific optimization in Criteria Alan Pinstein <apinstein at mac dot com> Alan Pinstein <apinstein at mac dot com> 2009-04-27 07:43:57 PDT
             Re: [propel-dev] PostgreSQL Specific optimization in Criteria Cameron Brunner <cameron dot brunner at gmail dot com> Cameron Brunner <cameron dot brunner at gmail dot com> 2009-04-27 08:06:26 PDT
                 Re: [propel-dev] PostgreSQL Specific optimization in Criteria Alan Pinstein <apinstein at mac dot com> Alan Pinstein <apinstein at mac dot com> 2009-04-27 08:20:43 PDT
                     Re: [propel-dev] PostgreSQL Specific optimization in Criteria Cameron Brunner <cameron dot brunner at gmail dot com> Cameron Brunner <cameron dot brunner at gmail dot com> 2009-04-27 08:23:31 PDT
                         Re: [propel-dev] PostgreSQL Specific optimization in Criteria Alan Pinstein <apinstein at mac dot com> Alan Pinstein <apinstein at mac dot com> 2009-04-27 08:29:40 PDT
                     Re: [propel-dev] PostgreSQL Specific optimization in Criteria hlellelid Hans Lellelid 2009-05-01 08:27:28 PDT
                         Re: [propel-dev] PostgreSQL Specific optimization in Criteria Cameron Brunner <cameron dot brunner at gmail dot com> Cameron Brunner <cameron dot brunner at gmail dot com> 2009-05-01 09:13:52 PDT
                             Re: [propel-dev] PostgreSQL Specific optimization in Criteria Cameron Brunner <cameron dot brunner at gmail dot com> Cameron Brunner <cameron dot brunner at gmail dot com> 2009-05-01 09:34:38 PDT
                                 Re: [propel-dev] PostgreSQL Specific optimization in Criteria Cameron Brunner <cameron dot brunner at gmail dot com> Cameron Brunner <cameron dot brunner at gmail dot com> 2009-05-01 09:50:29 PDT
                                     Re: [propel-dev] PostgreSQL Specific optimization in Criteria hlellelid Hans Lellelid 2009-05-01 14:13:44 PDT
                                         Re: [propel-dev] PostgreSQL Specific optimization in Criteria Cameron Brunner <cameron dot brunner at gmail dot com> Cameron Brunner <cameron dot brunner at gmail dot com> 2009-05-01 19:07:03 PDT
                                             Re: [propel-dev] PostgreSQL Specific optimization in Criteria hlellelid Hans Lellelid 2009-05-02 01:29:30 PDT
                                                 Re: [propel-dev] PostgreSQL Specific optimization in Criteria Cameron Brunner <cameron dot brunner at gmail dot com> Cameron Brunner <cameron dot brunner at gmail dot com> 2009-05-02 03:26:48 PDT
                                                     Re: [propel-dev] PostgreSQL Specific optimization in Criteria Alan Pinstein <apinstein at mac dot com> Alan Pinstein <apinstein at mac dot com> 2009-05-02 12:14:24 PDT
                                                         Re: [propel-dev] PostgreSQL Specific optimization in Criteria Cameron Brunner <cameron dot brunner at gmail dot com> Cameron Brunner <cameron dot brunner at gmail dot com> 2009-05-02 12:16:50 PDT
Messages per page: