We have a pretty large db in Oracle and I am trying to use a view (over 300k records, over 90 columns) to pull up the data. It takes forever. Any way to speed up the retrieval? Also, is there a way to create a record set on the server that is refreshed (say every 10 minutes)automatically that pulls up the entire view and then when users access the page, it looks at that record set rather than having to retrieve it all over again. Another question i have is paging through the record set. I used an example from http://www.asp101.com/samples/db_paging.asp, however it gets entire recordset every time. Is there a more efficient way to do this? Thanks!