Sunday, May 01, 2005

VSJ | Articles | Deep and speedy SQL

VSJ | Articles | Deep and speedy SQL: "Deep and speedy SQL

The new SQL Server 2005 Express Edition is aimed at developers – is it up to the job?

By Kay Ewbank

Published: Sunday, March 20, 2005

If you’re developing a database application and want to stay within the Windows fold, but not spend a fortune on the database server, your choices are somewhat limited. There are applications such as MySQL, PostgreSQL, and Firebird, and they each have their advantages. However, if you want to have the option of moving to a commercial product in the future, and in particular, if you prefer to use Microsoft products, your only option until now has been to use MSDE. The Microsoft Desktop Database Engine was something of a wallflower in publicity terms; it used the same engine as Microsoft’s SQL Server but had no real management tools or user interface. It was also limited in its performance by various performance and capacity ‘throttles’ to encourage you to move to ‘real’ SQL Server once your database application started having more than a few thousand records. You were also limited to having no more than five concurrent users of your MSDE databases."

No comments: