Re: MySQL Performance or Just me? :(

[ernest]

Tobin Harris wrote:
> You should paste your query here for us to see.

SELECT tableA.*, tableB.*, Count(DISTINCT tableA.session_id_initial) AS CountOfDistinctSII, SUM(tableA.visit_duration) AS CountOfVisitDuration, SUM(CASE WHEN session_state='n' THEN 1 ELSE 0 END) AS CountOfSessions, Count(tableA.pid) AS CountOfPID FROM tableB INNER JOIN tableA ON tableB.pid_id = tableA.pid WHERE (((tableA.datestamp)>='06-01-2005') AND ((tableA.datestamp)<='07-01-2005')) GROUP BY tableB.fullname

>
> Have you run an EXPLAIN on the query to see if
> it's using an index? For example:
>
> EXPLAIN select * from mytable where col = 'hello'
>

After running EXPLAIN, I got the following:

table type possible_keys key key_len ref rows Extra
tableB ALL NULL NULL NULL NULL 117 Using temporary; Using filesort
tableA ALL NULL NULL NULL NULL 434836 Using where