Re: [PERFORM] Partitioning / Clustering

2005-05-14 Thread PFC
If you make the assertion that you are transferring equal or less session data between your session server (lets say an RDBMS) and the app server than you are between the app server and the client, an out of band 100Mb network for session information is plenty of bandwidth. So if you count on a

Re: [PERFORM] Sort and index

2005-05-14 Thread Jim C. Nasby
On Thu, May 12, 2005 at 08:54:48PM +0200, Manfred Koizar wrote: On Wed, 11 May 2005 16:15:16 -0500, Jim C. Nasby [EMAIL PROTECTED] wrote: This is divided by the number of index columns, so the index correlation is estimated to be 0.219. That seems like a pretty bad assumption to make.

Re: [PERFORM] ok you all win what is best opteron (I dont want a hosed system again)

2005-05-14 Thread Joel Fradkin
Thank you much for the info. I will take a look. I think the prices I have been seeing may exclude us getting another 4 proc box this soon. My boss asked me to get something in the 15K range (I spent 30 on the Dell). The HP seemed to run around 30 but it had a lot more drives then the dell

Re: [PERFORM] ok you all win what is best opteron (I dont want a hosed system again)

2005-05-14 Thread Josh Berkus
Joel, The two worst queries (our case and audit applications) I created denormalized files and maintain them through code. All reporting comes off those and it is lightning fast. This can often be called for. I'm working on a 400GB data warehouse right now, and almost *all* of our queries