Re: Long-running queries

In article <3uk28e$ccg@lennon.cc.gatech.edu>, gukal@cc.gatech.edu says... > >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 >-- > > >------------------------------------------------------------------------ -------- > >Sreenivas Gukal Ph: 404-853-9390 > email: gukal@cc.gatech.edu > >------------------------------------------------------------------------ -------- In my experience, and in the collective experience of most postings that I have seen in this group, DSS and OLTP very rarely, if ever, are performed against the same database. In the Sybase applications that I have put together, one table scanning query can cause the entire OLTP system to block until the query finishes. Most solutions to the problem are to use multiple databases: one for OLTP, and the second for DSS. Ken Block Kinetic Consulting Inc. (401) 246-2740 kblock@kincon.com