Performance Questions 7.x

Posted in 1996

Carol Stimmel — 6 Mar 1996 22:34:20 GMT — source: Informix-list mailing list archive (1991-1998)

Sorry to followup my earlier post, but I thought I'd mention that we had great success in increasing our performance by, basically, dumping the whole thing and starting over. ;-) We re-worked the SELECT statements to NEVER, EVER use the word MATCH and the sucker is a screamer. This or course, required an entire rethinking of the database and how items were selected. Let this server as a warning to anyone who has a performance issue....avoid avoid MATCH!!!! IMNSHO. Thanks for all the help via email! -- Carol L. Stimmel, Systems Analyst NOAA/ERL/FSL work: stimmel@fsl.noaa.gov 325 Broadway home: stimmel@majordomos.com Boulder, CO 80303