Re: Speed / Server

> But you should plan on partitioning to multiple db servers up front
> and save pain of conversion later on. A dual socket motherboard with
> 16 to 32 SAS drives and a fast RAID controller is WAY cheaper than a
> similar machine with 4 to 8 sockets is gonna be. And if you gotta go
> there anyway, might as well spend your money on other stuff.
>
>
I agree. If you can partition that sensor data across multiple DBs and have
your application do the knitting you might be better off. If I may be so
bold, you might want to look at splaying the systems out across your
backends. I'm just trying to think of a dimension that you won't want to
aggregate across frequently.

On the other hand, one of these 16 to 32 SAS drive systems with a raid card
will likely get you a long way.