Re: MySQL Performance or Just me? :(

[Ernest Semerda]

> How does the EXPLAIN look now?

tableA ALL datestamp NULL NULL NULL 434839 Using where; Using temporary; Using filesort
tableB ref pid_id pid_id 25 tableA.pid 1



> > have you got links to resources which talk
> about optimising MYSQL?
>
> 1) This forum
> 2)
> http://dev.mysql.com/doc/mysql/en/mysql-optimizati
> on.html (be warned - it can be dense ;)
> 3)
> http://dev.mysql.com/tech-resources/articles/mysql
> -db-design-ch18.html (a nice story)
> 4) http://promysql.com/ (no doubt - but I haven't
> been able to put my hand on a copy yet)

fantastic! thank u Felix.

now time for more reading and learning :)