I guess we would need to get too far into the details of your design to answer this question... I do understand what your saying about the joins,...
I was just referring to what you said earlier, the reason you gave that row-oriented databases were too slow... You're saying two different...
I think the punishment is too harsh in this case...
Wow...how do you unsubscribe from a thread?
That's what I suspected. It's no wonder SQL Server wasn't performing well if you're trying to store hundreds of columns worth of intermediate...
I will agree that higher frequency systems have the potential to be more profitable than lower frequency systems, due to the longer coastline. I...
Neither can really be "predicted" due to chaotic factors, but both can be traded profitably.
Anyone with experience using hybrid drives? I haven't but it seems like a possible solution. Not sure if they can be used in a RAID array though...
Great, thanks for the input. I don't agree with your views, but it's nice to hear how other people are processing their data.
A flat file would be stored on a disk also, wouldn't it?
You're not required to read all columns when you join. Just use two subqueries that reference only the close price if that's all you need for the...
I think you've got a pretty good structure right there. I'd probably have a T&S table with symbol, consolidated timestamp, received...
Ok, I see what you mean by sliding window now. When I do a moving calculation like that, I usually have good results with something like the...
Nothing too fancy. Most of it is building indexes correctly and avoiding unnecessary duplication by using a larger number of simple tables rather...
True, regression isn't built in, but you can write custom functions to do that kind of math. Could you clarify what you mean by sliding windows?
I completely (but politely :)) disagree. It depends to a large part on table structures, indexes, etc. Not to mention the hardware setup and the...
Here's the thread I mentioned above, if anyone cares to discuss their feelings about SQL in detail:...
I use Sql Server as part of my setup, but I see a lot of negative reactions on ET about using this or other SQL databases. My use is for...
Porche's have nice shiny engines, but they will be disappointing to drive if you only use the first 3 gears. :D Again, it's all about how you...
Fair enough. I haven't had the issues with SQL that I hear other people complaining about here. I'd like to be the first to tell you that it...
Separate names with a comma.