Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
veggiop
Starting Member
10 Posts |
 Posted - 2011-06-22 : 02:40:00
|
| iam using c sharp and mssql for my coding....i have used an simple select statement in c sharp, which will be executed very fast. which is working fast for 50 times, but after that it is getting slow down. if i again issue the same command after 2 min, it is again running fast for 20 - 30 time, then again it is getting slow down.. the command is very simple,select productname from productdetail where productname<="abc";i was not able to find the reason for its slowness, please help me on this....http://www.fivefingers.me/vibram/ |
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2011-06-24 : 11:54:45
|
| How fast is "fast execution" and how slow is "slow" one? Is the where cluase always productName < 'abc' or it is each time productName < <some string>, where the string varies?MirkoMy blog: http://mirko-marovic-eng.blogspot.com/ |
 |
|
|
|
|
|
select query is getting slow