Re: Long-running queries

Posted in 1995

John Huegel — Mon, 24 Jul 95 15:00:34 GMT — source: Informix-list mailing list archive (1991-1998)

In article <3uk28e$ccg@lennon.cc.gatech.edu>, 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. I dont know how important >and/or frequent a problem this is in real applications. If you >have encountered similar situations, can you please let me >know the context you had the problem in and what your solution was. > >Regards We set up queries to run against a backup database, on a machine that does not support OLTP. We have essentially biased some of our machines toward OLTP activity, and others toward batch activity. Our Symix database is split into four physical databases on four machines (soon to become six), with two machines oriented to OLTP and two to batch/long queries. A substantial batch schedule allows much of this to be done at night/on weekends.