Miscellaneous > Applications

MySQL vs MSSQL Server, ASP vs JSP, IIS vs Apache

(1/1)

ims27_8:
ok, here's the deal. I'm a database programmer (at least that's how my job description reads), and my company has an upcoming project that requires a web site accessing a database. It's a very large system. My company is pro MS, and there's no way we'll get linux servers. But, i have been given a large say i what other tools we use for this project. IIS is a strong leader over apache, so much so that it may be a lost cause (i don't have much say in that area), but the others are up for contention. A while ago, a network engineer told the company had MSSQL server, and described it as "full blown SQL" implying MySQL (which i was using at the time) was an inferior product. I felt like saying "Just because it's MS doesn't mean it's the best out there, MySQL is just as good", but i had no real evidence to refer to, so i kept my mouth shut. I've never used JSP or ASP or java servlets or anything like that (although i know java). Has anyone here used these before, and if so, what are the advantages/disadvantages of each? I have some books on ASP and JSP that i am looking at at the moment, but any assitance would be appreciated.

flap:
Performance is one argument. MySQL isn't as fully featured as MSSQL as it's designed specifically with speed in mind, thus it's more appropriate for website backends than bigger DBMSs. That's why so many websites use it. So the fact that MSQQL is "full blown SQL" is exactly why you quite possibly don't need it. And if you do need a fully featured DBMS you could use Postgresql.

Kintaro:
I dont really care if big companys use Windows, even if it would be nice to have Linux more popular. What we need is less companys.

Corparation should be banned.

I dont have anything against companys, just when they try to ever capitalize.

TheQuirk:
Try PostgreSQL.

Navigation

[0] Message Index