Re: Long-running queries

Posted in 1995

Hans M. Aus — 26 Jul 1995 08:24:23 GMT — source: Informix-list mailing list archive (1991-1998)

In article <3v2917$pe3@news.decus.se>, WEIMANM@DECUS.SE (Magnus Weiman) wrote: > gukal@cc.gatech.edu (Sreenivas Gukal) wrote: > > >Hi Folks > >Part of my Ph.D. thesis deals with efficiently supporting long-running > >queries (maybe Decision Support System queries) without affecting > >concurrent transactions in an OLTP environment.... > The only really good way I have found so far to solve your problem is > to have a replicate database against which the long ad hoc queries are > run. ... > ... Sreenivas and Magnus, We also use a Sandbox copy of our production database. Works great and saves us all sorts of headaches. The Sandbox is not only for ad hoc and long queries, but also for program developing. I thought this was standard procedure and didn't realize that one could write a dissertation about it ;) -- 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