Click here to Skip to main content
15,795,789 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi everyone!
I am going to build project winform with C#
but I confuse that i should use firebird, SQL Server Compact Edition or SQL Server database ??

- somebody can advantages and disadvantages of firebird, SQL Server Compact Edition or SQL Server to optimize and access data faster, please !!
thank you so much

1 solution

That's not really a comparison: they don't all do the same thing.
FireBird and SQL Server are both Database server systems: they accept requests and supply information while acting as an interface between the actual disk storage and the application using the database. SQLCE isn't - it access the file directly.

The difference this makes is that Firebird and SQL Server are both usable in multiuser environments: SQLCE isn't because only one application (or even thread) can access the database at a time - it is strictly single user.

Firebird and SQL server are comparable and this has been done before - Google will find you quite a few, but here is one:[^]
Share this answer
sergio090588 28-Jul-13 22:54pm    
ok,thanks man!
yan can guide me to optimize and access database faster !!
you can help me,please!!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900