I'm new to C++ but have a lot of experience with databases. I often use ColdFusion and have learned how much faster SQL Server can be than Access or text databases. My program is now in SQL Server and ColdFusion, but I need it to be faster, so I'm rewriting it in C++.
My question is this: in terms of speed and performance, is it going to make a big difference to use SQL Server rather than Access or text via the C++ application? Or is the speed similar no matter what the data source? The database has hundreds of thousands of fields in each of several tables (5-6).
I've seen shareware/freeware C++ apps given out with huge text databases, and they run really fast. Is the difference negligible, or am I going to notice a big difference?
Is there any database format that works especially well with C++?
Is it going to help to have indexes (as it does when accessing data with a slower language like ColdFusion)?
Any other advice or considerations for me?