Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Querying many records

Status
Not open for further replies.
memi

memi

Programmer
Oct 17, 2001
7
IL
Hi Guys.

I need to query a table with about 1 million records in my ASP page.
I need to page this table. My system has about 1,000 users.
I know that if I'll use the paging mechanism in the ADO (pageSize, absolutePage, pageCount), all the data will be loaded to the server or client (which is IIS in this case), and if 50 users will load 1 million records each, the server probably will crash.

What can I do to avoid this? Did I miss something in the ADO?
 
Sort by date Sort by votes
Would it be feasible to break the table into seperate tables by ways of a stored procedure?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Insert (new) records in a table => question about the inputscreen
2
Replies
20
Views
362
ChrisHirst
ChrisHirst
Papa Bear
  • Locked
  • Question
Have I got too many if's
Replies
5
Views
105
MakeItSo
MakeItSo
cr84net2
  • Locked
  • Question
I need to join 5 tables with identical fields then reference the records by table
Replies
4
Views
145
guitarzan
guitarzan
emozley
  • Locked
  • Question
Formatting one to many results
Replies
7
Views
95
emozley
emozley
evr72
  • Locked
  • Question
Records double up after second log in 1
Replies
12
Views
159
evr72
evr72

Part and Inventory Search

Sponsor

Back
Top