search

waliwali / ibm-db

Automatically exported from code.google.com/p/ibm-db
0 stars 0 forks source link

Every single SQL query does an extra count() query #7

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
There is no requirement to return the rowcount from the execute() method
and the extra count() query that is executed every time could well be
costly. If the database server cannot return the number of affected rows
easily, I would recommend this be omitted from the return value of execute().

The "rowcount" attribute can retrieve the information lazily, if that's
desired, but we shouldn't have to pay this penalty for every single query.

Original issue reported on code.google.com by malc...@pointy-stick.com on 21 Mar 2008 at 7:56

GoogleCodeExporter commented 9 years ago 
In case it wasn't clear, this is in ibm_db_dbi.py.

Original comment by malc...@pointy-stick.com on 21 Mar 2008 at 8:12

GoogleCodeExporter commented 9 years ago

Original comment by apiti...@ca.ibm.com on 24 Mar 2008 at 8:58

GoogleCodeExporter commented 9 years ago

Original comment by swepa...@us.ibm.com on 24 Mar 2008 at 9:08

GoogleCodeExporter commented 9 years ago

Original comment by abhigyan...@in.ibm.com on 28 Apr 2008 at 2:15

GoogleCodeExporter commented 9 years ago

Original comment by abhigyan...@in.ibm.com on 28 Apr 2008 at 3:03

GoogleCodeExporter commented 9 years ago 
Fixed in ibm_db-0.2.9

Original comment by open...@us.ibm.com on 8 May 2008 at 1:44