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)
Is there a way to optimize my query/tables?
Thanks a lot...
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)
Code:
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...