You mentioned that the results don't return many rows. So if you are using a
lot of
aggregate functions (max, min, etc), it's possible to precalculate them
every night
and join on the precalculated values. Much faster. I also believe there are
data warehousing solutions that automatically precalc
I once had a similar problem with a few users monopolizing a database
server with looong running querys. The OS was NetWare with Oracle on a
2x500MhZ PII, 1Gb RAM and about 4-6Gb database.
When optimizing performance on this system I finally found that if I
split the main server into two different
re there, they wont one to create the perpetual mobile... ;)
You should consider to use one (or several) cursor in this case instead
of a big single query...
> - Theo
>
>-Original Message-
>From: Svensson, B.A.T. [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, May 17, 2001
ould
access the application until a query was done running.
- Theo
-Original Message-
From: Svensson, B.A.T. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 4:29 PM
To: Brinkman, Theodore; [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] Canceling a Query
Dear Brinkman,
With out h
o run?
I hope it will work out for you in the end!
Cheers,
/Anders
>-Original Message-
>From: Brinkman, Theodore
>[mailto:[EMAIL PROTECTED]]
>Sent: Thursday, May 17, 2001 9:34 PM
>To: [EMAIL PROTECTED]
>Cc: Svensson, B.A.T.
>Subject: RE: [PHP-WIN] Canceling a Quer
- Theo
-Original Message-
From: Svensson, B.A.T. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 3:10 PM
To: Brinkman, Theodore; [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] Canceling a Query
Dear Brinkman,
First I wonder one thing: Why are the queries long running
in the first
inal Message-
>From: Brinkman, Theodore
>[mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, May 16, 2001 5:45 PM
>To: [EMAIL PROTECTED]
>Subject: [PHP-WIN] Canceling a Query
>
>
>I'm working on an application for work where users will be querying the
>database to get inf
... evaluation conditions in the were clause
like 'where 1 = 2 ..' etc... :-)
>-Original Message-
>From: John Lim
>Sent: Thursday, May 17, 2001 9:00 AM
>To: [EMAIL PROTECTED]
>Subject: Re: [PHP-WIN] Canceling a Query
>
>
>Hello,
>
>This is a worka
Hello,
This is a workaround. Can you use T-SQL's: SET ROWCOUNT ?
This limits the number of rows returned by a query.
-- John
""Brinkman, Theodore"" <[EMAIL PROTECTED]> wrote in
message FE8510398BFE854F9653B5C32DBB652FD4F39E@oh_daytn_xch01">news:FE8510398BFE854F9653B5C32DBB652FD4F39E@oh_daytn_x
I'm working on an application for work where users will be querying the
database to get information back about processed documents. I'm trying to
set up a way for a user to cancel a query which is taking too long. I'm
using MS SQL Server 2000. The interface for the cancel is easy enough, a
form
10 matches
Mail list logo
