[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-11-03 Thread Jax Gibb (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15634300#comment-15634300 ] Jax Gibb commented on DERBY-6858: - I know this sounds simplistic, but I had a similar problem & modified

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-28 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15171007#comment-15171007 ] somebody commented on DERBY-6858: - Is anybody able to look at this issue please? > Apache Derby simple

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-21 Thread Mike Matrigali (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15156177#comment-15156177 ] Mike Matrigali commented on DERBY-6858: --- note that the decision between these two plans is even more

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-21 Thread Mike Matrigali (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15156174#comment-15156174 ] Mike Matrigali commented on DERBY-6858: --- The row count estimates the optimizer is using are likely

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-21 Thread Mike Matrigali (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15156137#comment-15156137 ] Mike Matrigali commented on DERBY-6858: --- note that deferred update is a different concept than

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-21 Thread Brett Bergquist (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15156027#comment-15156027 ] Brett Bergquist commented on DERBY-6858: I fired up jvisualvm and attached to SquirrelSQL and

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-21 Thread Brett Bergquist (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15156015#comment-15156015 ] Brett Bergquist commented on DERBY-6858: Another datapoint. I downloaded the repro and ran it in

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-21 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15155992#comment-15155992 ] somebody commented on DERBY-6858: - I really appreciate everyone's feedback and support. Unfortunately I

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-20 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15155850#comment-15155850 ] Bryan Pendleton commented on DERBY-6858: Thanks Mike! Your explanation of the deferred vs direct

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-20 Thread Mike Matrigali (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15155843#comment-15155843 ] Mike Matrigali commented on DERBY-6858: --- I also want to add that unfortunately one can no longer

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-20 Thread Mike Matrigali (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15155838#comment-15155838 ] Mike Matrigali commented on DERBY-6858: --- I am coming late to this discussion. mostly what i looked

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-20 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15155674#comment-15155674 ] Bryan Pendleton commented on DERBY-6858: I had no experience with Derby, either, when I started

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-20 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15155536#comment-15155536 ] somebody commented on DERBY-6858: - I don't see any way to vote for this issue. Maybe I can't vote for an

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-20 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15155538#comment-15155538 ] somebody commented on DERBY-6858: - Just curious, is anybody interested, even a little in fixing this

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-20 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15155535#comment-15155535 ] somebody commented on DERBY-6858: - Thanks for the feedback but I have no experience developing Apache

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-19 Thread Myrna van Lunteren (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15154152#comment-15154152 ] Myrna van Lunteren commented on DERBY-6858: --- darkassassin98/somebody, Your frustration is clear

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-19 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15154053#comment-15154053 ] somebody commented on DERBY-6858: - Hi Rick, thanks for the feedback, but the workaround of increasing the

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-18 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15153481#comment-15153481 ] Rick Hillegas commented on DERBY-6858: -- Bryan suggested a workaround: adjust your page size. He also

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-18 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15152171#comment-15152171 ] somebody commented on DERBY-6858: - Is anybody working on this issue? This is still a blocker for me. >

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-15 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15147923#comment-15147923 ] somebody commented on DERBY-6858: - Any update? > Apache Derby simple update statement performance becomes

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-11 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15143851#comment-15143851 ] somebody commented on DERBY-6858: - It would be much appreciated if somebody is working on this issue.

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-10 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15140657#comment-15140657 ] somebody commented on DERBY-6858: - As I mentioned before, this is a complete blocker for me and I am not

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-09 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15139760#comment-15139760 ] somebody commented on DERBY-6858: - Any progress? > Apache Derby simple update statement performance

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-09 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15140151#comment-15140151 ] Bryan Pendleton commented on DERBY-6858: I don't know that anyone is actively working on this. I

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-09 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15140193#comment-15140193 ] Bryan Pendleton commented on DERBY-6858: I ran an experiment with Derby 10.4.1.3, which was

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-02-04 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15132057#comment-15132057 ] somebody commented on DERBY-6858: - Any update Bryan? > Apache Derby simple update statement performance

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-01-31 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15125570#comment-15125570 ] somebody commented on DERBY-6858: - Those are interesting findings. I'm glad we could at least rule out

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-01-29 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15124411#comment-15124411 ] somebody commented on DERBY-6858: - Hi Bryan, Did u have any luck fixing this issue? > Apache Derby

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-01-28 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15121308#comment-15121308 ] somebody commented on DERBY-6858: - The deferrable constraint is needed by my program and regardless, I

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-01-27 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15120644#comment-15120644 ] Bryan Pendleton commented on DERBY-6858: I see that in your revised repro.java, your definition of

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-01-27 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15118954#comment-15118954 ] somebody commented on DERBY-6858: - Wouldn't the backtrace you provided be more useful when compared to the

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-01-27 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15118952#comment-15118952 ] somebody commented on DERBY-6858: - Thanks for getting back to me. I'm really glad you are also able to

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-01-26 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15117027#comment-15117027 ] somebody commented on DERBY-6858: - Hi Bryan, Thanks for looking into this. I will take a look at your

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-01-26 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15118173#comment-15118173 ] somebody commented on DERBY-6858: - Hi Bryan, Thanks for taking a stab at writing a simple java file to

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-01-26 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15118491#comment-15118491 ] Bryan Pendleton commented on DERBY-6858: I can confirm your findings with your updated

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-01-26 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15118505#comment-15118505 ] Bryan Pendleton commented on DERBY-6858: I captured a stack backtrace during the "slow" update

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-01-25 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15116211#comment-15116211 ] somebody commented on DERBY-6858: - Okay I changed the name column to int in ParentUpate and the parentName

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-01-24 Thread somebody (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15114298#comment-15114298 ] somebody commented on DERBY-6858: - I have tried almost everything but not that. I will give it a try as a

[jira] [Commented] (DERBY-6858) Apache Derby simple update statement performance becomes 1500% worse when adding one byte to a column

2016-01-23 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15113769#comment-15113769 ] Rick Hillegas commented on DERBY-6858: -- Haven't looked into this, but have you tried changing your