[TYPO3] Slow query

[Lukas]

Hi Daniel

Thanks for your response. Here's the output when I run the query with 
EXPLAIN:

Daniel Schledermann wrote:

[ Ändra ] [ Utan SQL-förklaring ] [ Skapa PHP-kod ]



table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
ISEC 	ref 	joinkey,rl0,rl0_2 	rl0_2 	4 	const 	1261 	Using where; Using 
index; Using temporary; Using f...
IR 	ref 	PRIMARY,wid 	PRIMARY 	4 	ISEC.phash 	178 	Using index
IW 	eq_ref 	PRIMARY 	PRIMARY 	4 	IR.wid 	1 	Using where


Utskriftsvänlig visningUtskriftsvänlig visnin



Daniel Schledermann wrote:
  > Try running it in phpmyadmin with:
> 
> EXPLAIN SELECT IR.phash
> FROM index_words IW,
> index_rel IR,
> index_section ISEC
> WHERE
> IW.baseword LIKE '%ängsholmmen%'
> AND IW.wid=IR.wid
> AND ISEC.phash = IR.phash
> AND ISEC.rl0 IN (130)
> AND is_stopword=0
> GROUP BY IR.phash;
> 
> Thats is always the first place to start debugging a slow SQL query. 
> This will give you information on how many rows scanned in the tables 
> involved.
> 
> /D