[EMAIL PROTECTED]
Subject: Re: [PHP-DB] sql optimizing
assistance
t you are using it. For more info:
http://www.mysql.com/doc/en/MySQL_indexes.html
On Fri, 19 Sep 2003 16:01:34 -0400, [EMAIL PROTECTED] spoke
thusly about Re: [PHP-DB] sql optimizing assistance:
>
> i new i forgot to include something.
>
> here this is the ouput. it looks like its
run this query:
EXPLAIN SELECT Question.Text_Long, AVG( Response ) FROM `Response` INNER JOIN
Question ON Question.Question_Key = Response.Question_Key WHERE
Question.Question_Key LIKE '2003%' GROUP BY Response.Question_Key ORDER BY
Question.Question_Key ASC
and post the results. This will descri
rter.net> Subject: Re: [PHP-DB] sql optimizing
assistance
From: <[EMAIL PROTECTED]>
> I have two tables and am running a simple join between them to get
> questions and their repsective response averages from a survey. The
> question table has 49 rows and the Response table has 126,732. I'd like
to
> cut down on the time its taking to run this specifi
I have two tables and am running a simple join between them to get
questions and their repsective response averages from a survey. The
question table has 49 rows and the Response table has 126,732. I'd like to
cut down on the time its taking to run this specific query...as i'll be
running many li