little design question...
hi,
A friend of mine created an 'excell and macro's'-based application that he uses for the ranking of competitors (a bit like the WTA ranking system: competitores get points on each tournament that you have to defend one year later...).
But now that he inserted about 1000 competitors,...the excell-program really starts to slow down, and he also wanted to add some extra features to it...so he asked me if it would be possible to port it to a standalone VC++ application.
Now my question is -before I start coding- : Will the VC++ version (using the normal serialization and so) also start to slow down when the 'counter' hits 1000 entries?
Or should I consider making this a database-applicacation? (which I don't have a lot of experience with yet,...)
You see, I'd really give this program a shot when I'm certain of it's speed/stability whe having more than -let's say- 1500 or 2000 competitors in the list. Maybe this is a simple (stupid?) question but if someone could briefly tell me the limitations/pro's & con's of the different collection classes and so, that would really be helpful.
thx in advance!
2000 competitors? ...piece of cake!
In the C++ version, simply read/write 2000 records from/to a file and and process them, will be much more faster than using Excel VBA, that's for sure.
But if your problem is a little bit more complex, it's quite difficult to handle and process data, and to maintain the application because of a lot of hard-coded stuff.
So, port it to C++ but use a database!.
If you don't have a lot of experience using databases, what's the problem?
Just start digging ;)