I created a VIEW which JOINS 6 files. I do a GROUP BY so that I can SUM a few columns. It's pretty sluggish the first time in, which is expected, and then runs quicker each call after that. Would I be better off removing the GROUP BY in my VIEW and moving it into the RPG code where I use the VIEW or will this make no difference?
It's just a bit of a drag since it's a web application and I've time out a few times. I do send the user a message that they've time and to search again, which comes back almost instantly, but I don't think it's a great user experience!
Thanks in advance as usual.
It's just a bit of a drag since it's a web application and I've time out a few times. I do send the user a message that they've time and to search again, which comes back almost instantly, but I don't think it's a great user experience!
Thanks in advance as usual.
Comment