Question
MYSQL (0.5 Seconds) vs. MSSQL (16 Seconds)
My testtable has 2 columns and 37.000 records in 2 Versions:
MySQL 5.x and MSSQL 2008.
I have build CFCs with simple SQLqueries (Select all, without a where-clause) for both databasesystems.
The CFCs are called by a CFM-Dump-File in my Browsers
The MYSQL-Result is back in approximately 0.5 seconds and shows all records in the browser.
The MSSQL-Resultdump takes 16 ( ! ) seconds and shows only the first 10.000 Records in the browser.
It does't matter if I try IE7 or Firefox 3.
What is going wrong with MSSQL?
Thank you for helping!
Anton
My Software:
Windows XP
Coldfusion 8
MySQL 5
SQLServer2008-Express
SQL JDBC Driver 1.2
JRE Version 7
All Servicepacks and Hotfixes are installed.
I have build CFCs with simple SQLqueries (Select all, without a where-clause) for both databasesystems.
The CFCs are called by a CFM-Dump-File in my Browsers
The MYSQL-Result is back in approximately 0.5 seconds and shows all records in the browser.
The MSSQL-Resultdump takes 16 ( ! ) seconds and shows only the first 10.000 Records in the browser.
It does't matter if I try IE7 or Firefox 3.
What is going wrong with MSSQL?
Thank you for helping!
Anton
My Software:
Windows XP
Coldfusion 8
MySQL 5
SQLServer2008-Express
SQL JDBC Driver 1.2
JRE Version 7
All Servicepacks and Hotfixes are installed.
AdChoices