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 |
|
nix
Starting Member
4 Posts |
 Posted - 2003-03-13 : 15:34:03
|
| Hi,I have a access database and a table with over 50,000 rows and my problem is that I takes for ever to list the whole table in a asp-page.I separated it with the alphabet:SELECT * FROM table WHERE name LIKE ‘A%’ ORDER BY nameBut the letter K still have over 6,000 rows and take to long time to list.Is there any one that no how to list 100 rows at the time?Edited by - nix on 03/13/2003 15:36:42 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-03-20 : 13:36:35
|
| Is the backend SQL Server or Access? Can you change the structure of the table? Does it have an identity column on it?You could do (if you have an identity column):Select @Max = Max(idCol), @Min = Min(idCol) From Table where name like 'a%'Select * from table Where idCol Between @Min And @Min + 100just make sure it doesn't go over max.NOW for the better question?Who's going to look at 6,000 rows of data in the first place (or scroll through it if you are able to implement the above).You criteria needs to allow for better data miningBrett8-) |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-03-20 : 13:46:56
|
| Look at rollingstone.com. When you browse for an artist by name, they break it out like "Aa-Ac", "Ad-Ah", etc ... not just by first letter.Maybe that approach will work for you?Brett - I think he said he's using Access, btw.- Jeff |
|
|
|
|
|
|
Split a query in small pieces