Table prefix makes WordPress

[joaomiguel]

In IIS using MySql.

If the table prefix on config file is on upper case and the db has the tables prefix in lower case, each page takes 4-5 seconds to load.
Correcting the value it takes less then 1 second.

It's a very difficult problem to debug because there is no errors and everything works fine.

The upper case to lower case can easily happen if the db has the lower case tables option active (I think it's the default for MySql)

[pento]

This likely due to Windows NTFS being case insensitive: MySQL can use a table even if the table name has the wrong case, but there may be issues.

This scenario is unsupported by WordPress, you should correct the case of the table prefix in your wp-config.php file.