I wonder how somebody can approve such a query and tables.
1) There is no indexes, thats the main reason for the time and cpu consuming.
At least,
the fields used in the joins MUST be indexed.
2) varchar(255) on ALL fields? That's unlikely, in-cre-di-ble. Right type for
the right
data, int for
j llarens wrote:
2) varchar(255) on ALL fields? That's unlikely, in-cre-di-ble. Right type for the right
data, int for numbers, float for money, char for fixed string, and certainly NOT 255 for
lenght! If its necesary such amount of characters, TEXT or BLOB must be used, but only if
it is
My responses blended in
Jason Johnson [EMAIL PROTECTED] wrote on 04/04/2005 02:19:12 PM:
The premise of the query is to return required continuing education
hours for the entire membership of the organization. Limited to one
member when providing a membership ID.
The query is a
I have been struggling to maintain decent performance on a web/database
server for a good 6 months now due to MySQL performance issues. I have
decided that my best option at this point is to take it to the list, so
in advance, I thank you all for taking a look.
There is no error messages that
On Apr 4, 2005, at 1:22 PM, Jason Johnson wrote:
I have been struggling to maintain decent performance on a
web/database server for a good 6 months now due to MySQL performance
issues. I have decided that my best option at this point is to take it
to the list, so in advance, I thank you all for
The premise of the query is to return required continuing education
hours for the entire membership of the organization. Limited to one
member when providing a membership ID.
The query is a little bulky, and fortunately I cannot take credit for
its design, but here goes (keep in mind that
At 12:22 PM 4/4/2005, you wrote:
I have been struggling to maintain decent performance on a web/database
server for a good 6 months now due to MySQL performance issues. I have
decided that my best option at this point is to take it to the list, so in
advance, I thank you all for taking a look.
: Monday, April 04, 2005 1:30 PM
To: MySQL list
Subject: Re: Performance Tuning - Table Joins
At 12:22 PM 4/4/2005, you wrote:
I have been struggling to maintain decent performance on a web/database
server for a good 6 months now due to MySQL performance issues. I have
decided that my best option