My next motherboard

I just noticed this post. Thanks for the tip but I need to research what you are saying since I don't know what it means.

Thanks again.

nitro
Quote from Trader.NET:

You can try cluster index (the rows will be physically stored in sequential order if the indexed columns are in sequential order such as 1, 2, 3, 4, ... ) on the symbol id and timestamp using a high fill factor such as 90% to optimize query performance while adding some hit on inserts.

Storing a series per symbol per table will be slow compared to storing a series in an image column per row per symbol.

The fastest way to retrieve a series is to store it (an array of market data) in a serilalized blob like image column.
More...
 
Quote from ozzy:

Is that really necessary with dual-core CPU's just around the corner?
More...
On a quad board, dual cores turn it into an EIGHT WAY machine :eek: :eek: :eek:

nitro :D
 
I have done some preliminary tests on the Dell running releae version of 64-bit Windows for extended systems (EMT64.)

The machine seems a little slower than even the Quad Opteron running on 32-bits, and the Quad Opteron when run under 64-bit windows blows the EMT64 machine away.

In fact, I compared the machine against a dual Xeon 400 Mhz FSB machine (the Dell is an 800Mhz FSB machine) and they are very compable when you normalize for CPU speeds (the dell has two 2.8 Ghz Xeons, while the other machine has 2.4 Ghz Xeons.)

All in all, what this tells me is that barring something that I am missing, the Intel EMT64 systems and Hyperthreading are vastly inferior to the 800 series AMD processors in 64-bit mode and that Intel is mostly marketing hype on it's current processors.

Some might argue that 800 series Opterons should only be compared to Intel Itanium processors, but the Itaniums are really expensive and inferior to the AMD 800s.

nitro
 
As an aside, I am installing Debian Linux on the old dual Xeon as part of some stock market research that I have wanted to do for a long time.

I thought I would give my first impressions about Debian and so far it runs like a bat out of hell. In addition, it is very easy to get and install packages with apt-get.

nitro
 
I'm glad Debian is still alive and kicking. I used to be a volunteer developer for it back in the day (4 years ago). You're absolutely right about it being fast, and apt-get.. there is no comparison.
 
You must log in or register to reply here.
Back
Top