Quote from: Agelmar on December 15, 2001, 08:03:00 PMI'm going to be doing the testing on MS SQL, but to be honest, I really don't think the speed differences will be that great between MS SQL and MySQL... no really advanced SQL queries are used, just the basics... I'm currently running Beta Release 14 of YaBBSE on a Windows 2000 Server with IIS5 and PHP 4.1.0 (latest release) with MySQL 3.23.46-nt (latest release). It works absolutely fine, like a breeze. Install of MySQL was quick and painless (a lot less so than MS SQL Server 7 and SP3...)
Well, making it fast would certainly need a lot of rewriting the code (here we go again), but using datashaping providers (much like odbc), you can retrieve the relational tables as objects in a hierarchic structure (like a directory structure). That combination makes it possible to write one query, and retrieve all information in one go for the whole screen.
With the speed Microsoft SQL will retrieve that data, immense speeds can be achieved.
Author