Hello,
Explain where the Statement is very fast:
*************************** 1. row ***************************
table: Stuecke
type: ALL
possible_keys: PRIMARY,St_Autor
key: NULL
key_len: NULL
ref: NULL
rows: 694
Extra: Using where; Using temporary; Using filesort
*************************** 2. row ***************************
table: StueckBilder
type: ref
possible_keys: StB_StueckID
key: StB_StueckID
key_len: 5
ref: Stuecke.St_ID
rows: 3
Extra: Using where
*************************** 3. row ***************************
table: St_Aufg_Pers_V
type: index
possible_keys: St_Aufg_Pers_V_StueckID
key: St_Aufg_Pers_V_StueckID
key_len: 15
ref: NULL
rows: 863
Extra: Using where; Using index; Distinct
3 rows in set (0.00 sec)
explain from the slow machine:
*************************** 1. row ***************************
table: Stuecke
type: ALL
possible_keys: PRIMARY,St_Autor
key: NULL
key_len: NULL
ref: NULL
rows: 694
Extra: Using where; Using temporary; Using filesort
*************************** 2. row ***************************
table: StueckBilder
type: ref
possible_keys: StB_StueckID
key: StB_StueckID
key_len: 5
ref: Stuecke.St_ID
rows: 3
Extra: Using where
*************************** 3. row ***************************
table: St_Aufg_Pers_V
type: index
possible_keys: St_Aufg_Pers_V_StueckID
key: St_Aufg_Pers_V_StueckID
key_len: 15
ref: NULL
rows: 863
Extra: Using where; Using index; Distinct
3 rows in set (0.00 sec)
In my opinion there are no differences.
How does the cpu power influence the speed of a query?
Regards,
Spiker
--
Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten
Browser-Versionen downloaden: http://www.gmx.net/de/go/browser
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
