public marks

PUBLIC MARKS with tags performance & sqlserver

12 July 2006 12:15

Simon's Software Stuff: SQL Server performance tips

by springnet
Does your SQL statement have a WHERE clause? I know this sounds obvious, but don't retrieve more data than you need. However, less obvious is that even if your SELECT statement retrieves the same quantity of data without a WHERE clause, it may run faster

PUBLIC TAGS related to tag performance

apache +   applications +   benchmark +   benchmarking +   bookmarks +   browsers +   cacti +   code +   comparison +   computer +   configuration +   css +   database +   design +   development +   english +   fastcgi +   firefox +   guide +   html +   humor +   internet +   kde +   lamp +   linux +   lynx +   memory +   microsoft +   mysql +   network +   news +   opera +   php +   programming +   reference +   research +   ruby +   scaling +   scgi +   scripts +   security +   server +   tips +   tools +   tutorial +   tutorials +   tweaks +   web +   webdesign +   windows +  

Active users

springnet
last mark : 12/07/2006 12:20