Professional Web Applications Themes

Caching RecordSet - ASP Database

Hi, I need an input! I am working on an ASP web application that allow customers to order products from the web site. The products pages show only 20 products at a time, I would like to avoid to requery the table every time the user to navigate between pages (I do not know big the table could be). Is there a way to cache the recordset or a way to make it available "public" from page to page? thank you in advance serge...

  1. #1

    Default Caching RecordSet

    Hi,

    I need an input! I am working on an ASP web application that allow
    customers to order products from the web site. The products pages show
    only 20 products at a time, I would like to avoid to requery the table
    every time the user to navigate between pages (I do not know big the
    table could be). Is there a way to cache the recordset or a way to make
    it available "public" from page to page?

    thank you in advance
    serge

    Serge Myrand Guest

  2. #2

    Default Re: Caching RecordSet

    Thank you very much
    serge

    "Aaron [SQL Server MVP]" wrote:
    > You could use XML data islands, or store the pages in HTML. However, this
    > won't help when someone runs a search...
    >
    > Or, you could use a more efficient paging mechanism.
    > [url]http://www.aspfaq.com/2120[/url]
    >
    > --
    > [url]http://www.aspfaq.com/[/url]
    > (Reverse address to reply.)
    >
    > "Serge Myrand" <infosoftdelirium.qc.ca> wrote in message
    > news:40E16796.223716FFsoftdelirium.qc.ca...
    > > Hi,
    > >
    > > I need an input! I am working on an ASP web application that allow
    > > customers to order products from the web site. The products pages show
    > > only 20 products at a time, I would like to avoid to requery the table
    > > every time the user to navigate between pages (I do not know big the
    > > table could be). Is there a way to cache the recordset or a way to make
    > > it available "public" from page to page?
    > >
    > > thank you in advance
    > > serge
    > >
    Serge Myrand Guest

  3. #3

    Default Re: Caching RecordSet

    You could use XML data islands, or store the pages in HTML. However, this
    won't help when someone runs a search...

    Or, you could use a more efficient paging mechanism.
    [url]http://www.aspfaq.com/2120[/url]

    --
    [url]http://www.aspfaq.com/[/url]
    (Reverse address to reply.)




    "Serge Myrand" <infosoftdelirium.qc.ca> wrote in message
    news:40E16796.223716FFsoftdelirium.qc.ca...
    > Hi,
    >
    > I need an input! I am working on an ASP web application that allow
    > customers to order products from the web site. The products pages show
    > only 20 products at a time, I would like to avoid to requery the table
    > every time the user to navigate between pages (I do not know big the
    > table could be). Is there a way to cache the recordset or a way to make
    > it available "public" from page to page?
    >
    > thank you in advance
    > serge
    >

    Aaron [SQL Server MVP] Guest

Similar Threads

  1. ASP Caching
    By Mahesh in forum ASP.NET General
    Replies: 3
    Last Post: July 16th, 11:44 AM
  2. Caching in FMS 2.0.4
    By abhongir in forum Macromedia Flash Flashcom
    Replies: 1
    Last Post: January 11th, 06:34 PM
  3. web svc caching
    By Saverio Tedeschi in forum ASP.NET Web Services
    Replies: 0
    Last Post: July 17th, 01:43 PM
  4. Replies: 8
    Last Post: September 24th, 11:07 AM
  5. .NET Web Caching
    By Tim in forum ASP.NET General
    Replies: 3
    Last Post: August 6th, 07:50 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139