Datas to MySQL - Really slow

[Lapinbleu]

Hello everybody,

 

I've downloaded the entire DMOZ datas and parsed them with dmoz2mysql PHP script.

I've added IDs on tables.

 

From now, when I do requests like this one, it's really slow (60sec) the first time it's done (thanks to MySQL cache)

 

SELECT DISTINCT
`content_links`.`topic`,
`content_links`.`resource`,
`content_description`.`title`,
`content_description`.`description`
FROM
`content_links` ,
`content_description`
WHERE
`content_links`.`topic` LIKE "Top/Shopping/Publications/Books/Arts" AND
`content_description`.`externalpage` = `content_links`.`resource`

 

Is there a way to optimize my query/tables?

 

Thanks a lot...

[Jacob Mathai]

If you mean optimize the execute times of queries -- you may consider looking at the mysql mailing lists for performance tuning best practices.

 

http://lists.mysql.com/