Hi everyone, unfortunately I don't know anything about databases, but I'm writing an application on a desktop computer (just one computer will access db, its not on a server) and it will be using a big amount of data (at least 10 million records, each record 1KB).
I think access database cant handle this amount of data fast enough, so I wanna know which DBMS is better for this situation and what is the requirement for the application to run on the destination computer.
* the program is written in c# and I will access the database directly with SQL commands, not linq or other things.
Thanks in advance ;)