SQL-Query too long?

[marinelli82]

Hello,

I am quite new at MySQL, and that forum =)
My question is how long SQL-queries may be.. because I have several tables in my database and have to link some of them to get my wished data..
Now I could send my request by one SQL statement:

SELECT ma.benutzername, at.abteilung, sd.datum, sd.projekt_nr, kd.kunde, kd.kunden_nr, lf.lieferant, lf.lieferanten_nr, sd.bestell_nr, sd.lieferschein_nr, sd.intern, pz.prozess
FROM stammdaten AS sd,
mitarbeiter AS ma,
abteilungen AS at,
kunden AS kd,
lieferanten AS lf,
prozesse AS pz
WHERE datensatzID = 2
AND erstellerID = mitarbeiterID
AND ma.abteilungsID = at.abteilungsID
AND sd.kundenID = kd.kundenID
AND sd.lieferantID = lf.lieferantID
AND sd.prozessID = pz.prozessID


or split it in several requests..
Which method will be faster?
Or shall I restructure my tables anyway if I need such complex requests to get my wished data?

thanks a lot

bye

Andy

 

[ericbrunson]

I've written queries 10 times longer than that.

I would write the query that makes sense and if the performance is bad, look at tuning the query and indexing your data.