Zend Framework

Call to UPPER Db function slowing query

Details

  • Type: Performance Improvement Performance Improvement
  • Status: Resolved Resolved
  • Priority: Minor Minor
  • Resolution: Won't Fix
  • Affects Version/s: 1.8.0
  • Fix Version/s: None
  • Component/s: Zend_Db_Adapter_Db2
  • Labels:
    None

Description

On line 414 (and I assume line 394 is the same) of the DescribeTable method of Zend_Db_Adapter_Db2 there are two calls to UPPER. When this call is made, my queries run substantially slower. If I remove the call a query taking 15-25 seconds drops to <1 second.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Satoru Yoshida added a comment -

The table name has always capital letter only ?
If not, the change is danger, I think.

Show
Satoru Yoshida added a comment - The table name has always capital letter only ? If not, the change is danger, I think.
Hide
Permalink
Simon Verberne added a comment -

When creating tables with the iSeries Navigator, the tables are always created with all capitals for me. So, that is not an issue.... yet. The thing that concerns me more is the difference in the amount of time required to run a script with and without that call to UPPER.

I am relatively new to the iSeries and so may have missed the option to not have the tables named with all capitals.

Show
Simon Verberne added a comment - When creating tables with the iSeries Navigator, the tables are always created with all capitals for me. So, that is not an issue.... yet. The thing that concerns me more is the difference in the amount of time required to run a script with and without that call to UPPER. I am relatively new to the iSeries and so may have missed the option to not have the tables named with all capitals.
Hide
Permalink
Satoru Yoshida added a comment -

I ensure that I can create table with small letter on i5/OS by following.
CREATE TABLE TESTLIB."mytable" .....

And I can also create on DB2 for non-i5/OS.
CREATE TABLE "mytable" .....

So, I think this issue should be "Won't Fix" .

Show
Satoru Yoshida added a comment - I ensure that I can create table with small letter on i5/OS by following. CREATE TABLE TESTLIB."mytable" ..... And I can also create on DB2 for non-i5/OS. CREATE TABLE "mytable" ..... So, I think this issue should be "Won't Fix" .

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Zend Framework. Try JIRA - bug tracking software for your team.