Lookup Tables in Webservice

Discussion in 'ASP .Net Web Services' started by Michael C#, May 10, 2005.

  1. Michael C#

    Michael C# Guest

    I have 4 - 5 lookup tables in a SQL Server database. What's the best (or
    recommended) way to read all these values into memory for my Web Service one
    time, so I don't have to keep opening connections to the server and pulling
    the same records across the network?

    Thanks
     
    Michael C#, May 10, 2005
    #1
    1. Advertising

  2. Michael C#

    Brock Allen Guest

    You can utilize the HttpContext.Current.Cache in your webservice.

    -Brock
    DevelopMentor
    http://staff.develop.com/ballen



    > I have 4 - 5 lookup tables in a SQL Server database. What's the best
    > (or recommended) way to read all these values into memory for my Web
    > Service one time, so I don't have to keep opening connections to the
    > server and pulling the same records across the network?
    >
    > Thanks
    >
     
    Brock Allen, May 10, 2005
    #2
    1. Advertising

  3. Michael C#

    Michael C# Guest

    Thank you, I'll give it a shot!

    "Brock Allen" <> wrote in message
    news:...
    > You can utilize the HttpContext.Current.Cache in your webservice.
    >
    > -Brock
    > DevelopMentor
    > http://staff.develop.com/ballen
    >
    >
    >
    >> I have 4 - 5 lookup tables in a SQL Server database. What's the best
    >> (or recommended) way to read all these values into memory for my Web
    >> Service one time, so I don't have to keep opening connections to the
    >> server and pulling the same records across the network?
    >>
    >> Thanks
    >>

    >
    >
    >
     
    Michael C#, May 10, 2005
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Demetri
    Replies:
    0
    Views:
    341
    Demetri
    Oct 15, 2003
  2. Jack
    Replies:
    0
    Views:
    364
  3. Adrian Charteris

    XSLT Lookup Tables Help.

    Adrian Charteris, Oct 15, 2004, in forum: XML
    Replies:
    4
    Views:
    955
    Adrian Charteris
    Oct 18, 2004
  4. John Collyer

    Function lookup tables?

    John Collyer, Oct 4, 2003, in forum: C++
    Replies:
    12
    Views:
    1,300
    Karl Heinz Buchegger
    Oct 6, 2003
  5. Replies:
    6
    Views:
    309
Loading...

Share This Page