Results 1 to 9 of 9

Thread: To use Cache or not

Threaded View

  1. May 27th, 2004, 11:27 AM #1
    wey97
    wey97 is offline

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2000
    Location
    Birmingham, AL
    Posts
    1,276

    Resolved To use Cache or not

    I have a page that I need to show individual record values from a SQL Server database (not a datagrid) and buttons to navigate through the records.

    This happens to be a very large DataSet.

    I have two options:

    1) Cache the Dataset and get a single DataRow for every navigation

    2) Use a stored procedure to return one row at a time with a select statement. An example would be navigating through the records in order such as "SELECT TOP 1 * FROM Table WHERE Key_Value > 'Current_Value' ORDER BY Key_Value ASC"

    What are the tradeoffs of both and are there any better ways to do this?
    Last edited by wey97; Nov 10th, 2004 at 09:46 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width