MySQL 5 vs MS SQL server 2005 (1 Viewer)

[tourettes]

I think using MS SQL Compact Edition would be another choice which should be good enough and you wouldn't have to deal with having to setup an SQL server (I don't see this as a problem but for many less technical users it might be).

If I remember correctly MS SQL compact dont support multiple clients accessing the database. With TVE3's architechture (bad or not, but not going to change) all clients use the DB directly.

 

[bermag]

If I remember correctly MS SQL compact dont support multiple clients accessing the database. With TVE3's architechture (bad or not, but not going to change) all clients use the DB directly.

It does support multiple concurrent access but that is probably only on the same machine and not networked clients.

I thought MP clients were accessing the server using remoting or something and not accessing the database directly.

 

[eXDee]

I know theres probably still no definative answer...
But what MySQL 5.1 vs SQL Server 2008? I have a copy of Visual Studio i use for development and so i can that instead. Someone told me 2008 has 'a lot of optimizations' however im not sure which is ideal.