Re: SELECT JOIN Abfrage viel zu langsam
Die Abfragegeschwindigkeit betrÃĪgt jetzt 0,5 sec.
Entscheident wird die Angabe von "rows" sein, oder ?
table type possible_keys key ref rows Extra
projekte ALL PRIMARY,idx_aktiv_name 24 Using where;
Using temporary;
Using filesort
vorgaenge ref idx_proj_calcnr_id, idx_proj_calcnr_id zikula.projekte.projekt_id 22 Using where
idx_erl_anf_end_id
aufgaben ref idx_vorg_aufg_lfdnr idx_vorg_aufg_lfdnr zikula.vorgaenge.vorgang_id 42
vorgang_ressourcen_gruppen ref idx_vorg_gruppe idx_vorg_gruppe zikula.vorgaenge.vorgang_id 2 Using index
ressourcen_gruppen_mitglieder ref idx_proj_res idx_proj_res zikula.projekte.projekt_id 17
ressourcen eq_ref PRIMARY PRIMARY zikula.ressourcen_gruppen_mitglieder.ressource_id 1
Subject
Views
Written By
Posted
4516
March 17, 2011 08:05AM
2428
March 17, 2011 08:15AM
1729
March 17, 2011 09:31AM
1664
March 17, 2011 02:13PM
2221
March 18, 2011 12:49AM
Re: SELECT JOIN Abfrage viel zu langsam
1584
March 21, 2011 03:10AM
1702
March 21, 2011 09:58AM
3068
March 22, 2011 06:42AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.