Warning: Can't synchronize with repository "(default)" (/home/git/ome.git does not appear to be a Git repository.). Look in the Trac log for more information.
Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Task #9109 (new)

Opened 12 years ago

Last modified 8 years ago

RFE: support temp_ids in PostgreSQL

Reported by: jamoore Owned by:
Priority: minor Milestone: Unscheduled
Component: ORM Version: n.a.
Keywords: n.a. Cc: jburel
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: n.a.
Sprint: n.a.

Description

As a part of #3961, temp_ids support was committed which was broken for !PostgreSQL. This didn't show up until #9077 where large queries of the form where x in (:ids) with a list of ids longer than 1000 was executed. Since such large queries are very slow in PostgreSQL (at least in the 8.x series) it might be worth fixing the support.

Change History (1)

comment:1 Changed 8 years ago by jamoore

  • Milestone changed from Future to Unscheduled
Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.62409 sec.)

© 2000-2014 University of Dundee & Open Microscopy Environment. Creative Commons Attribution 3.0 Unported License
OME source code is available under the GNU General public license or through commercial license from Glencoe Software

We're Hiring!