RE: Thoughts on Logical Log use requested

Posted in 2006

Simmons, Keith — Wed, 15 Mar 2006 16:00:25 -0000 — source: Usenet: comp.databases.informix

Malcolm Not in such polite and illustrious company. I thought our application suppliers were bad (nary a primary key or unique index in sight !!) but this certainly seems worse. Are they building indexes on the temp tables? or letting the engine do it? Keith -> -----Original Message----- -> From: mweallans@panacea.co.uk [mailto:mweallans@panacea.co.uk] -> Sent: Wednesday, March 15, 2006 3:42 PM -> To: informix-list@iiug.org -> Subject: Re: Thoughts on Logical Log use requested -> -> -> Well I found mine. As usual it is BAD applications developers. -> -> How's this for classic code -> -> SELECT * from tablename INTO TEMP tabtemp1; -> SELECT * FROM tabtemp1 -> WHERE ..... -> INTO tabtemp2; -> SELECT * FROM tablename2 INTO TEMP tabtemp3; -> SELECT * FROM tabtemp3 -> WHERE .... -> INTO tabtemp4; -> SELECT ... FROM tabtemp2 WHERE join_condition; -> -> I've deliberately left out the table names and where clauses -> to protect -> the innocent. -> -> And if I tell you that the two permanent tables concerned are -> Master-Detail and each has in excess of 2,000,000 rows. -> And this poor customer is complaining about performance. -> -> Can anybody suggest how I tell the customer to correct the problem. -> -> regards -> -> Malcolm -> -> _______________________________________________ -> Informix-list mailing list -> Informix-list@iiug.org -> http://www.iiug.org/mailman/listinfo/informix-list -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. **********************************************************************************