...

View Full Version : how to test the speed of SQL processing in SQL...



NinjaTurtle
02-06-2003, 01:05 AM
Dear,

im now have two different SQL Statements and i want to test out the speed of this two SQL Statements, what should i do? like i want is show the processing usage time? posssible?

allida77
02-06-2003, 01:10 AM
Try this:
http://www.indus-soft.com/winsql/

Look for the "WinSQL Lite - FREE" utility.

I use this tool all the time at work.
If you happen to have MSSql server there is a "Query Analyzer" tool that installs with MS SQL Server.

NinjaTurtle
02-06-2003, 01:53 AM
Yes, i do have Query Analyzer but how to check the time usage?
is that the Statistic tab?

Morgoth
02-08-2003, 05:14 PM
You mean like how long it takes the page to load while doing sql stuff???

http://www.askasp.com/articles.asp?ArtID=85



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum