Consider Sun's new line of Opterons. They've been around for a couple of
years under the Newisys name. I'm using dozens of them for web servers
and PG servers and so far both the v20z and v40z have been excellent
performers with solid reliability. The pricing was also competitive
since Sun is look
Cott Lang wrote:
Consider Sun's new line of Opterons. They've been around for a couple of
years under the Newisys name. I'm using dozens of them for web servers
and PG servers and so far both the v20z and v40z have been excellent
performers with solid reliability. The pricing was also competitive
Most of mine I got through a Sun reseller. Some of mine I got off of
Ebay. You should be able to get them a lot cheaper than than retail web
pricing. :)
However, even full retail seems like it was a hell of a lot cheaper for
a v40z than a DL585. :)
On Fri, 2004-12-03 at 06:30 -0800, Joshua D. D
Cott Lang wrote:
Most of mine I got through a Sun reseller. Some of mine I got off of
Ebay. You should be able to get them a lot cheaper than than retail web
pricing. :)
However, even full retail seems like it was a hell of a lot cheaper for
a v40z than a DL585. :)
That's true :) One of the rea
We were originally heading towards an IBM deployment, but the 325 was
all that was available at the time, and it only supported 12GB. Then
when I heard they canceled their rumored quad processor 350, I feared
Intel/AMD politics and IBM dropped from the running. :)
(IBM now has the 326 that suppor
Hi
I see this article about DB2
http://www-106.ibm.com/developerworks/db2/library/techarticle/dm
-0411rielau/?ca=dgr-lnxw06SQL-Speed
The listing 2 example:
1 SELECT D_TAX, D_NEXT_O_ID
2 INTO :dist_tax , :next_o_id
3 FROM OLD TABLE ( UPDATE DISTRICT
4 SET D_NEXT_O_I
Hi Rod!
Thomas> Index scans are not always faster, and the planner/optimizer knows
Thomas> this. VACUUM ANALYZE is best run when a large proportion of data
Thomas> has been updated/loaded or in the off hours to refresh the
Thomas> statistics on large datasets.
>> While I agree that
Jean-Gerard,
> The listing 2 example:
> 1 SELECT D_TAX, D_NEXT_O_ID
> 2 INTO :dist_tax , :next_o_id
> 3 FROM OLD TABLE ( UPDATE DISTRICT
> 4 SET D_NEXT_O_ID = D_NEXT_O_ID + 1
> 5 WHERE D_W_ID = :w_id
> 6 AND D_ID = :d_id
Hi Folks,
I have two queries that are of the form :
select ... from ... where ... in (list1) AND ... in (list2). The two
queries differ only in the size of list2 by 1, but their performances
are quite different. Query2 runs much faster than Query1. The queries
are:
Query 1:
SELECT svm,pmo
The listing 2 example:
1 SELECT D_TAX, D_NEXT_O_ID
2 INTO :dist_tax , :next_o_id
3 FROM OLD TABLE ( UPDATE DISTRICT
4 SET D_NEXT_O_ID = D_NEXT_O_ID + 1
5 WHERE D_W_ID = :w_id
6 AND D_ID = :d_id
7 ) AS
Clinging to sanity, [EMAIL PROTECTED] (Pailloncy Jean-Gérard) mumbled into her
beard:
> I see this article about DB2
> http://www-106.ibm.com/developerworks/db2/library/techarticle/dm
> -0411rielau/?ca=dgr-lnxw06SQL-Speed
>
> The listing 2 example:
> 1 SELECT D_TAX, D_NEXT_O_ID
> 2 INTO :dist
On Fri, 03 Dec 2004 06:38:50 -0800, Joshua D. Drake
<[EMAIL PROTECTED]> wrote:
> That's true :) One of the reasons the compaq's are expensive
> is they supposedly use a quad board, even for the dual machine.
> Which means a different opteron chip as well.
I can confirm that. You have a choice of
(Originally asked in [General], realized that it would probably be
better asked in [Perform]:
I am curious as to how much overhead building a dynamic query in a
trigger adds to the process. The example:
Have a list of subcontractors, each of which gets unique pricing. There
is a total of roughly
Hi Folks,
I have two queries that are of the form :
select ... from ... where ... in (list1) AND ... in (list2). The two
queries differ only in the size of list2 by 1, but their performances
are quite different. Query2 runs much faster than Query1. The queries
are:
Query 1:
SELECT svm,pmo
14 matches
Mail list logo
