- Joined
- Mar 26, 2012
- Messages
- 1,465
- Reaction score
- 131
I would like to have an open discussion about this. I have moved from the old school mssql to sqlsrv and have stopped using the unreliable Xampp server as so many are still using. Let's discuss the benefits vs. the drawbacks of both systems.
IIS - Designed to run 24/7 in a working environment and comes with Windows(free). Capable of running PHP for both MSSQL and much more.
Xampp - Great for development of websites. Not designed for 24/7 use. MSSQL protocol hangs in it all the time to cause the site to crash.
SQLSRV - Faster than the old MSSQL protocol that so many are using. Can use prepared statements to avoid sql injection.
MSSQL - Old and outdated. Works well for Tantra Websites and very easy to use. Does not use prepared statements. Some queries will exceed the 60 second rules for Xampp. Forced to use extra scripts to block sql injection.
If you guys have any other thoughts please feel free to let us hear them. Thanks
IIS - Designed to run 24/7 in a working environment and comes with Windows(free). Capable of running PHP for both MSSQL and much more.
Xampp - Great for development of websites. Not designed for 24/7 use. MSSQL protocol hangs in it all the time to cause the site to crash.
SQLSRV - Faster than the old MSSQL protocol that so many are using. Can use prepared statements to avoid sql injection.
MSSQL - Old and outdated. Works well for Tantra Websites and very easy to use. Does not use prepared statements. Some queries will exceed the 60 second rules for Xampp. Forced to use extra scripts to block sql injection.
If you guys have any other thoughts please feel free to let us hear them. Thanks