yahoo-eng-team team mailing list archive

[Rodolfo Alonso <1925528@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Current "NeutronDbObject.objects_exist" implementation generates a query
(quite complex most of the time) to retrieve an OVO object. That usually
implies a large set of register columns, joined queries or subqueries.
Then, the method adds the "count" SQL syntagm to return only the number
of registers found.

This query can be optimized by:
- Limiting the number of registers to be retrieved to only one. The goal of the "objects_exist" method is to know if there are objects or not. Finding one is enough
- Limiting the complexity of the query by requesting only one column, provided as a method parameter, that could be, for example, the ID.

** Affects: neutron
     Importance: Wishlist
     Assignee: Rodolfo Alonso (rodolfo-alonso-hernandez)
         Status: New

** Changed in: neutron
   Importance: Undecided => Wishlist

** Changed in: neutron
     Assignee: (unassigned) => Rodolfo Alonso (rodolfo-alonso-hernandez)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1925528

Title:
  Improve "NeutronDbObject.objects_exist" performance

Status in neutron:
  New

Bug description:
  Current "NeutronDbObject.objects_exist" implementation generates a
  query (quite complex most of the time) to retrieve an OVO object. That
  usually implies a large set of register columns, joined queries or
  subqueries. Then, the method adds the "count" SQL syntagm to return
  only the number of registers found.

  This query can be optimized by:
  - Limiting the number of registers to be retrieved to only one. The goal of the "objects_exist" method is to know if there are objects or not. Finding one is enough
  - Limiting the complexity of the query by requesting only one column, provided as a method parameter, that could be, for example, the ID.

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1925528/+subscriptions