Hi all, each time that someone say: this query is slow, this query take forever, bla bla bla all our request are:
1) Which version are you running ? 2) May I see your table definition? 3) May I see you configuration file? 4) May I see the explain ? 5) ....... sometimes a beginner is scared about all these questions and even he/she don't know how do collect these informations and we lose important data about: "why that damn query is too slow"? may be is usefull generate an automatic report that take charge of collect all these informations and send it to a file or directly to [EMAIL PROTECTED] , may be something like: > BEGIN REPORT TO FILE <file_name> > SELECT ...... > END REPORT; or > BEGIN REPORT TO EMAIL <address> > SELECT ...... > END REPORT; Regards Gaetano Mendola ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
