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
Dear Brinkman,
First I wonder one thing: Why are the queries long running
in the first place? Might it be because improper indexing
of the attribute in the tables? Maybe it can be worth to
have alook at this to see if you can increase performance
this way. You might very well be able to speed up
... 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
