Why is a SQL query executing slower in PHP than in Query Analyzer

I

iio

New Member
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?We are using SQL Server 2000 which I do not believe is the problem.[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.Any Ideas?Thanks
 
You must log in or register to reply here.
Back
Top