Re: Long-running queries

Posted in 1995

Hans M. Aus — 27 Jul 1995 09:09:07 GMT — source: Informix-list mailing list archive (1991-1998)

In article <3v5pl7$15i@excepcion.cc.gatech.edu>, gukal@cc.gatech.edu (Sreenivas Gukal) wrote: > Thanks a bunch to all the people who have responded (either personally > or on the net). Most of the replies fall into two categories. > > 1. Run the queries at less than degree 3 isolation. > > 2. Maintain a copy of the database and run queries on it. > ... > Besides the queries do not see the current data. How many ad hoc and or long running queries need today`s data ? Weekly, monthly and quarterly reports and billing probably don't. -- Cheers, Hans M. Aus, Wuerzburg, aus@vax.rz.uni-wuerzburg.d400.de Inst. for Virology, Univ. of Wuerzburg tel.: --49 (0)931 201 3963; fax: --49 (0)931 201 3934