Hi,
I have three table joined to retrieve data using mysql. Tested Code like
SELECT Test.name1, Exper.exper1, Try.try1, Try.try2 FROM Test LEFTt JOIN Exper ON Test.name2 = Exper.exper2.ChipID LEFT JOIN Try ON Test.name3 = Try.try3 WHERE Test.test1="HGUA11" AND Exper.exper1>"1000";
Speed is very slow, I didnt wait for result, then aborted it.
In realistic condition, I may select much more columns than aboved shew.
Have any suggestions? where is my problems?
I have three table joined to retrieve data using mysql. Tested Code like
SELECT Test.name1, Exper.exper1, Try.try1, Try.try2 FROM Test LEFTt JOIN Exper ON Test.name2 = Exper.exper2.ChipID LEFT JOIN Try ON Test.name3 = Try.try3 WHERE Test.test1="HGUA11" AND Exper.exper1>"1000";
Speed is very slow, I didnt wait for result, then aborted it.
In realistic condition, I may select much more columns than aboved shew.
Have any suggestions? where is my problems?