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 |
|
bulubuk1976
Starting Member
24 Posts |
 Posted - 2008-03-18 : 10:10:07
|
| When I want to display the total records (#) in a webpage, it is very slow. When I try to remove the total records and show them per 20s, it responds very fast.Any ideas? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-18 : 10:12:40
|
| What is the query you are using for this?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
bulubuk1976
Starting Member
24 Posts |
Posted - 2008-03-18 : 10:22:58
|
I am using no filter. But I want to show 20 in the least per page. It works fine. But when I add the items " Results 1 to 20 of 300,000" it is very slow and it times out most of the time.quote:
Originally posted by harsh_athalye
What is the query you are using for this?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
|
|
|
|
|
|
|
Slow Query