Hi pawel:
On Thu, Sep 24, 2015 at 11:56 AM, <pawel(dot)samysev(at)gmail(dot)com> wrote:
Not seeing the whole query I cannot say too much but:
> WHERE
> p.phone_id BETWEEN :min AND :max
¿ Are you sure you're not getting fencepost overlaps when substituting
:min/:max ? ( between does closed intervals, normally half closed (
phone_id >= min and phone_id<max ) are used for this kinds of queries
( I ask because it seems a query doing b-c could lock out other doing
a-b for a long time ).
Francisco Olarte.