RE: Re: Optimizing..

--openmail-part-000bd2fc-00000001 Content-Type: multipart/alternative; boundary=openmail-part-000bd2fc-00000002 --openmail-part-000bd2fc-00000002 Content-Type: text/plain; charset=ISO-8859-1; name="BDY.RTF" Content-Disposition: inline; filename="BDY.RTF" Content-Transfer-Encoding: quoted-printable Whats the point in people sendin gin problems they have like the one below, when you get dickheads that answer peoples queries saying 'Attend= a course' or 'read the manual' how does that help someone?. The person with the problem may have already tried to fin d the answer in the manual and may not understand it, or can't find it. Why not give them a= decent answer to the question. I thought this mailing list was for people to share knowledge and experience, not take the piss out of people that know less than us. Anyway Abel, to be the best help I can, to optimise a query you really need to look at the fields you are qureying on in the 'WHERE clause' of your statment. Each query is (should be) unique and there is a limit to= how well the query will perform. Indexing will help your speed of retriveal, but has its own overheads of using more space. Plus, using too many indexes could actually SLOW the query. Mail me personally if you want with the specific query and any detail of the tables within it i.e. indexes and jins and I'll see if I can help. Jamie ---------- From: billy Sent: 07 April 1998 07:15 To: abelrg; informix-list Cc: billy Subject: Re: Optimizing.. =20 =20 -- NOTE: This Electronic Mail Message has been =20 checked by Anti-Virus Software. If you have any queries please contact the MIS Department (Extn. 7050). =20 -- =20 =20 On 6 Apr 98 at 18:38, ABEL ROJAS GARCIA wrote: =20 > What can I do for Optimizing queries? =20 Well, you should certainly attend a performance optimising course. =20 You can also try experimenting with SET EXPLAIN ON and reading the =20 manual. =20 HTH. =20 -- =20 /Ciao, \\\\Billy / \\\\Group Managing Director, The West Solutions Group: http://www.west.co.za / Chairman, South African Informix User Group: http://www.west.co.za/~saiug \\\\ Drivel @ http://www.west.co.za/tasteless/ / \\\\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I / think we should go along with him..." \\\\____________________________________________________________________= ____________________________ =20 =20 --openmail-part-000bd2fc-00000002 Content-Type: application/rtf; name="BDY.RTF" Content-Disposition: attachment; filename="BDY.RTF" Content-Transfer-Encoding: base64 {\\rtf1\\ansi\\deff0\\deftab720{\\fonttbl{\\f0\\fswiss MS Sans Serif;}{\\f1\\froman\\fcharset2 Symbol;}{\\f2\\fswiss Arial;}{\\f3\\fswiss Arial;}} {\\colortbl\\red0\\green0\\blue0;\\red0\\green0\\blue255;} \\deflang2057\\pard\\plain\\f2\\fs20\\cf1 Whats the point in people sendin gin problems they have like the one below, when you get dickheads that answer peoples queries saying 'Attend a course' or 'read the manual' how does that help someone?. The person with the problem may have already tried to fin d the answer in the manual and may not understand it, or can't find it. Why not give them a decent answer to the question. I thought this mailing list was for people to share knowledge and experience, not take the piss out of people that know less than us. \\par \\par Anyway Abel, to be the best help I can, to optimise a query you really need to look at the fields you are qureying on in the 'WHERE clause' of your statment. Each query is (should be) unique and there is a limit to how well the query will perform. Indexing will help your speed of retriveal, but has its own overheads of using more space. Plus, using too many indexes could actually SLOW the query. Mail me personally if you want with the specific query and any detail of the tables within it i.e. indexes and jins and I'll see if I can help. \\par \\par Jamie \\par \\par \\pard\\li1800\\fi-1440\\tx1440\\plain\\f0\\fs16\\protect ---------- \\par \\plain\\f0\\fs16\\b\\protect From: \\plain\\f0\\fs16\\protect \\tab billy \\par \\plain\\f0\\fs16\\b\\protect Sent: \\plain\\f0\\fs16\\protect \\tab 07 April 1998 07:15 \\par \\plain\\f0\\fs16\\b\\protect To: \\plain\\f0\\fs16\\protect \\tab abelrg; informix-list \\par \\plain\\f0\\fs16\\b\\protect Cc: \\plain\\f0\\fs16\\protect \\tab billy \\par \\plain\\f0\\fs16\\b\\protect Subject: \\plain\\f0\\fs16\\protect \\tab Re: Optimizing.. \\par \\par \\pard\\li360\\plain\\f3\\fs20\\protect \\par -- \\par NOTE: This Electronic Mail Message has been \\par checked by Anti-Virus Software. If you \\par have any queries please contact the MIS \\par Department (Extn. 7050). \\par -- \\par \\par \\par On 6 Apr 98 at 18:38, ABEL ROJAS GARCIA wrote: \\par \\par > What can I do for Optimizing queries? \\par \\par Well, you should certainly attend a performance optimising course. \\par You can also try experimenting with SET EXPLAIN ON and reading the \\par manual. \\par \\par HTH. \\par \\par -- \\par \\par /Ciao, \\par \\\\Billy \\par / \\par \\\\Group Managing Director, The West Solutions Group: \\plain\\f3\\fs20\\cf1\\ul\\protect\\lnkd http://www.west.co.za\\plain\\f3\\fs20\\protect \\par / Chairman, South African Informix User Group: \\plain\\f3\\fs20\\cf1\\ul\\protect\\lnkd http://www.west.co.za/~saiug\\plain\\f3\\fs20\\protect \\par \\\\ Drivel @ \\plain\\f3\\fs20\\cf1\\ul\\protect\\lnkd http://www.west.co.za/tasteless/\\plain\\f3\\fs20\\protect \\par / \\par \\\\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I \\par / think we should go along with him..." \\par \\\\________________________________________________________________________________________________ \\par \\par \\pard\\li360\\plain\\f2\\fs