#798: Performance improvements accessing products table
---------------------------+-------------------------------
Reporter: olemis | Owner: nobody
Type: enhancement | Status: new
Priority: major | Milestone:
Component: multiproduct | Version: 0.8.0dev
Resolution: | Keywords: product table sql
---------------------------+-------------------------------
Changes (by olemis):
* owner: => nobody
* keywords: => product table sql
* component: => multiproduct
Old description:
New description:
I'm getting the following entries in the log . AFAICT , to me this is
initially a query requesting all rows in product table . Later it is
obviously a kind of loop iterating over existing products and retrieving
exactly the same information for each row using where clause . So , what
should take a `2 ms` to be completed , actually takes about `51 ms` in
practice , resulting in an excessive an unnecessary overhead .
{{{
2014-04-14 13:52:41,230 Trac[util] DEBUG: SQL: SELECT
"prefix","name","description","owner" FROM bloodhound_product
2014-04-14 13:52:41,232 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,232 Trac[util] DEBUG: args: [u'dataviz']
2014-04-14 13:52:41,234 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,234 Trac[util] DEBUG: args: [u'review']
2014-04-14 13:52:41,235 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,236 Trac[util] DEBUG: args: [u'rest']
2014-04-14 13:52:41,237 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,237 Trac[util] DEBUG: args: [u'themes']
2014-04-14 13:52:41,238 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,238 Trac[util] DEBUG: args: [u'labs']
2014-04-14 13:52:41,239 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,239 Trac[util] DEBUG: args: [u'kanban']
2014-04-14 13:52:41,241 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,241 Trac[util] DEBUG: args: [u'openid']
2014-04-14 13:52:41,242 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,242 Trac[util] DEBUG: args: [u'persona']
2014-04-14 13:52:41,243 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,243 Trac[util] DEBUG: args: [u'pastebin']
2014-04-14 13:52:41,245 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,245 Trac[util] DEBUG: args: [u'widgets']
2014-04-14 13:52:41,247 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,247 Trac[util] DEBUG: args: [u'codegen']
2014-04-14 13:52:41,248 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,249 Trac[util] DEBUG: args: [u'social']
2014-04-14 13:52:41,250 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,250 Trac[util] DEBUG: args: [u'mda']
2014-04-14 13:52:41,252 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,252 Trac[util] DEBUG: args: [u'mockups']
2014-04-14 13:52:41,254 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,254 Trac[util] DEBUG: args: [u'vcshooks']
2014-04-14 13:52:41,256 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,256 Trac[util] DEBUG: args: [u'webhooks']
2014-04-14 13:52:41,257 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,257 Trac[util] DEBUG: args: [u'xmpp']
2014-04-14 13:52:41,259 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,259 Trac[util] DEBUG: args: [u'dev']
2014-04-14 13:52:41,260 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,260 Trac[util] DEBUG: args: [u'wysiwyg']
2014-04-14 13:52:41,261 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,261 Trac[util] DEBUG: args: [u'rpc']
2014-04-14 13:52:41,262 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,263 Trac[util] DEBUG: args: [u'semantic']
2014-04-14 13:52:41,264 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,264 Trac[util] DEBUG: args: [u'bhnet']
2014-04-14 13:52:41,266 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,266 Trac[util] DEBUG: args: [u'django']
2014-04-14 13:52:41,268 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,268 Trac[util] DEBUG: args: [u'forge']
2014-04-14 13:52:41,270 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,270 Trac[util] DEBUG: args: [u'qa']
2014-04-14 13:52:41,272 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,272 Trac[util] DEBUG: args: [u'reqs']
2014-04-14 13:52:41,273 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,274 Trac[util] DEBUG: args: [u'io']
2014-04-14 13:52:41,276 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,277 Trac[util] DEBUG: args: [u'biz']
2014-04-14 13:52:41,278 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,279 Trac[util] DEBUG: args: [u'swlcu']
2014-04-14 13:52:41,280 Trac[util] DEBUG: SQL: SELECT
prefix,name,description,owner FROM bloodhound_product
WHERE "prefix"=%s
2014-04-14 13:52:41,281 Trac[util] DEBUG: args: [u'trash']
}}}
--
--
Ticket URL: <https://issues.apache.org/bloodhound/ticket/798#comment:1>
Apache Bloodhound <https://issues.apache.org/bloodhound/>
The Apache Bloodhound issue tracker
