Re: Long-running queries

In article <806612021snz@granby.demon.co.uk>, Bruce Horrocks <bh@granby.demon.co.uk> wrote: >Mostly the requirement that I have to implement is for what I would >call "direct access", e.g. looking up a customer's details while >they're on the phone. While this does not necesssarily imply the same >volume of transactions that I would expect with OLTP, it still means >that any degradation in response time caused by a long-running query >is unacceptable. One good solution to this problem is to use optimistic concurrency control method together with timestamps. This way the long-running queries will "see" the contents of the database exactly as they were when the query started (with no locking at all), while the OLTP applications can just go on with their transactions. SOLID Server provides this functionality and is available in over 10 operating systems ranging from Intel(NT, OS/2, Linux) to RISC UNIXes. For more information on SOLID Server, send email to info@solid.fi Regards, Janne Karjalainen