June 28, 2007 at 9:09 am
Hi,
I have executed a query in sybase12.5.3 and sqlserver2000 server.
I find very huge difference in execution time.
Sybase : 8 Minutes
Sqlserver : 1 hour 10 minutes
I dont know,why sqlserver taking so long time ?
**************************************************
Can anybody explain me the architecture difference between sybase and sqlserver during query execution ?
***************************************************
Note : The same query is used in the sybase.
Can anybody help me ?
*Karthik
karthik
June 28, 2007 at 9:23 am
Since SQL Server is not inherently 9 times slower than Sybase, there's no definitive answer I can give without getting a lot more detail. It could be caused by anything from cached versus uncached data, different indexing methods, different table sizes it's dealing with, different memory amounts, out of date statistics, or just about anything else.
The query text, as well as as a lot of information about the data being worked with might help lead us in the right direction. Showplan might also shed some light.
June 28, 2007 at 11:44 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply