Re: [PERFORM] slow query on tables with new columns added.

2011-09-26 Thread Filip Rembiałkowski
2011/9/26 M. D. > I have full access to the database, but no access to the application > source code. If creating an index will help, I can do that, but with the > columns I don't see it helping as I don't have access to the application > source to change that. > > So yes, by changing settings,

Re: [PERFORM] slow query on tables with new columns added.

2011-09-26 Thread M. D.
I have full access to the database, but no access to the application source code.  If creating an index will help, I can do that, but with the columns I don't see it helping as I don't have access to the application source to change that. So yes, by changing setting

Re: [PERFORM] slow query on tables with new columns added.

2011-09-23 Thread Filip Rembiałkowski
2011/9/23 M. D. > > I did a software upgrade, and with it came a new feature where when > selecting a customer it queries for the sum of a few columns. This takes 7 > seconds for the 'Cash Sale' customer - by far the most active customer. I'd > like to see if it's possible to get it down a bit b

[PERFORM] slow query on tables with new columns added.

2011-09-23 Thread M. D.
Hi everyone, I did a software upgrade, and with it came a new feature where when selecting a customer it queries for the sum of a few columns. This takes 7 seconds for the 'Cash Sale' customer - by far the most active customer. I'd like to see if it's possible to get it down a bit by changin