About puelo

puelo · 04-13-2022

I am currently trying to analyze why one particular query performs worse than expected. While doing that i noticed that the query plan shown when executing the query manually does not match up with the query plan used when the query is dispatched by ...

puelo · 07-05-2017

Hello,we deployed our SAPUI5 application successfully to the HCP and it works fine in every major browser. It seems that there are some problem when opening the URL in a WebView in Android though. We get this error message in the logcat:"Uncaught Err...

puelo · 05-08-2017

I am having a weird problem with one specific site in my SAPUI5 application where model data gets lost if i navigate back and then forward again. The view consists of two lists which are populated from the same list inside the model like this:First L...

puelo · 04-19-2017

I am currently trying to extend the Input element to change and extend some HTML around it (labels and icons). Therefore i am doing something similar to this:http://jsbin.com/pipacaxuwi/edit?html,css,outputSadly it seems like by doing so i am also ov...

puelo · 04-23-2022

After the help of the comment section and more analyzing, the difference in query plans was caused by not using a prepared statement when executing the query manually, which obviously will have another query plan. After using the same prepared statem...

puelo · 04-23-2022

lars.breddemann Thanks for the detailed answer. Yes, i was able to reproduce the bad performance in Eclipse with HANA Tools and a prepared statement. As you already said the step to "Materialize Results" takes the most time. We went with the solutio...

puelo · 04-21-2022

lars.breddemann I think i found why the generated plans were different: I didn't take into account that the statement comes as a prepared statement from our server which obviously leads to a different query plan compared to a query with "fixed" par...

puelo · 04-15-2022

lars.breddemann The index on the number column was only added after we noticed the bad performance of the query in an, futile, attempt to remedy this.The volume indeed has changed (~1M new entries in a somewhat short span of time) so this might be ...

puelo · 04-14-2022

jbrandeis Thanks! We eliminated the need to check with wildcards (so no LIKE '%%'). That, unsurprisingly, sped up the query significantly. It would still be interesting to find out why the other queries were executed differently. Do you think it mig...

User Statistics

User Activity

Different query plan when trying to analyze performance

SAPUI5 Application not working in WebView

Model data gets lost on browser navigation

Extended Input with custom renderer is losing data binding

Re: Different query plan when trying to analyze performance

Re: Different query plan when trying to analyze performance

Re: Different query plan when trying to analyze performance

Re: Different query plan when trying to analyze performance

Re: Different query plan when trying to analyze performance