Did I hit a limit in the number of symbols in Market Analyzer?

[SirHC]

Hello,

I'm sure i will experiencing same problem of that thread.
I just want to add my thought.
1)Microsoft Access is easy to use and a good DB for small processing.
But when you need to process millions of lines, ( for example, 6 millions lines for 20 years of daily bars on 1200 stocks, just daily...), application need to be well designed but overall database must be the most. Did you do performance tests before choosing Access with SQL Server or other real DB ? What are you thinking about your choice?

2)You said it takes 5 seconds to load 10 hours* 60 min * 15 days = 9000 lines. Did you try to optimize this?

Regards and congratulations for your work.

[NinjaTrader_Dierk]

a) Jet engine performance is irrelevant for that scenario.
b) Not sure what you mean by optimize.

[SirHC]

Data load performance

a) you re right. "For larger database needs, Jet databases can be upgraded (or in Microsoft parlance, "up-sized") to Microsoft's flagship database product, SQL Server 2005"
So what sort of limitation can you suggest to your costumers for having a good experience of NT ?

b)I mean : Did you try to reduce that 5s? 10000 lines must be processed in less than 0.25 s, isn't it?

[NinjaTrader_Dierk]

>> So what sort of limitation can you suggest to your costumers for having a good experience of NT ?
You don't have any other option than using the JET engine.

>> Did you try to reduce that 5s? 10000 lines must be processed in less than 0.25 s, isn't it?
Sorry, not sure what math you are referring to. I suggest trying by yourself to gain your own experience on the actual implementation.

[SirHC]

I would just know how you have considered this part of your application.

Thanks for your answer.