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 |
|
bryan99y
Starting Member
42 Posts |
 Posted - 2003-06-11 : 12:06:22
|
| What is a good way to implement paging of records?stored procedure? application code? |
|
|
dsdeming
479 Posts |
Posted - 2003-06-11 : 13:10:50
|
| Try searching this site for "paging". There are at least two relevant articles and no telling how many forum posts.Dennis |
 |
|
|
bryan99y
Starting Member
42 Posts |
Posted - 2003-06-11 : 13:26:22
|
| not good solutions. temp table. not good for me. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-11 : 13:30:32
|
| What's not good about them? They are pretty efficient. Have you even tested them yet? I would love to see how you implement paging without a temp table.Tara |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-06-11 : 13:32:59
|
Look at:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25496my solution doesn't use a temp table, and it's pretty efficient.I've referenced this technique many times now and haven't seen a negative comment yet, so I assume it must work pretty well (or no one understands it or has tried it yet!) - JeffEdited by - jsmith8858 on 06/11/2003 13:34:43 |
|
|
|
bryan99y
Starting Member
42 Posts |
Posted - 2003-06-11 : 13:45:34
|
| tduggan...we have about 100 page hits per second. Temp. table are a performance problem. and yes - I have tested with them. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-06-11 : 23:09:54
|
| Bryan -- any comments on what i posted?- Jeff |
|
|
|
|
|
|
paging of records