| If you keep using the DISTINCT keyword you are goning to kill your Performance.
When you use DISTINTC, you are forcing SQL to arrange all the data and then to selecT the ones that are difernet. Its a huge overhead and the performance will suffer a lot. Do you have duplicated data than forces you to use Distinct? And if you do have duplicated data then since its duplicated you dont need to store it.
Use indexes and keys to make sure you are not storing duplicated information.
Avoid using DISTINCT as much as possible.
__________________ Quote:
Originally Posted by Lusiphur  Best raiding game ? Wow. | |