Author Topic: MySQL vs MSSQL Server, ASP vs JSP, IIS vs Apache  (Read 1519 times)

ims27_8

  • Member
  • **
  • Posts: 45
  • Kudos: 0
MySQL vs MSSQL Server, ASP vs JSP, IIS vs Apache
« on: 24 February 2003, 17:07 »
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

  • Member
  • **
  • Posts: 1,268
  • Kudos: 137
MySQL vs MSSQL Server, ASP vs JSP, IIS vs Apache
« Reply #1 on: 24 February 2003, 22:53 »
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.
"While envisaging the destruction of imperialism, it is necessary to identify its head, which is none other than the United States of America." - Ernesto Che Guevara

http://counterpunch.org
http://globalresearch.ca


Kintaro

  • Member
  • **
  • Posts: 6,545
  • Kudos: 255
  • I want to get the band back together!
    • JohnTate.org
MySQL vs MSSQL Server, ASP vs JSP, IIS vs Apache
« Reply #2 on: 25 February 2003, 02:34 »
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

  • VIP
  • Member
  • ***
  • Posts: 2,154
  • Kudos: 315
MySQL vs MSSQL Server, ASP vs JSP, IIS vs Apache
« Reply #3 on: 26 February 2003, 04:12 »
Try PostgreSQL.