Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#34 use DELETE FROM WHERE [query]

2.0x
closed
nobody
None
5
2005-05-14
2005-04-27
mstone
No

The delete algorithm currently retrieves all the
sid,cid pairs associated with a query, then deletes
them one at a time. It should be more efficient to
simply use the query as the WHERE clause in the case of
a "delete entire query". (Note that this should only be
done when referential integrity is being used.)

Discussion

  • Kevin Johnson
    Kevin Johnson
    2005-05-14

    Logged In: YES
    user_id=836228

    The DB engine is being replaced in 2.0. This will be part
    of that.

    Kevin

     
  • Kevin Johnson
    Kevin Johnson
    2005-05-14

    • milestone: --> 2.0x
    • status: open --> closed