I have a query that takes 5 seconds to run in SQL Server Managment Studio, but it takes 33 seconds in PHP to run the same query using *$qid=db_query($countQuery);* Has anyone got any idea why this might be?

Biz sorun inanmıyorum SQL Server 2000 kullanıyorsanız.

[edit] After doing some profiling we noticed that the execution plans were completely different between the analyzer and the query from PHP. This was done on a single machine, web, sql and query analyzer.

Herhangi bir düşünce?

Teşekkürler