#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
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks