Optimizations

Discussion in 'ASP .Net' started by niju, Aug 21, 2005.

  1. niju

    niju Guest

    Hi there
    I have a database table that has 1 column and 780 rows. The table is
    static. What is the best way to retrieve and populate the data into
    dataset, On Application start or caching?

    Many Thanks
    Niju
     
    niju, Aug 21, 2005
    #1
    1. Advertising

  2. niju

    tom pester Guest

    Application vars and Cache are equaly fast AFAIK, they both reside in memory.

    Use the cache if you want to free up memory if your server is in need of it.
    A cahced item gets removed if it ain't used while an app var is always there.

    Let me know if you have any more questions...

    Cheers,
    Tom Pester

    > Hi there
    > I have a database table that has 1 column and 780 rows. The table is
    > static. What is the best way to retrieve and populate the data into
    > dataset, On Application start or caching?
    > Many Thanks
    > Nij
     
    tom pester, Aug 21, 2005
    #2
    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. =?Utf-8?B?Sm9obiBHcmFudA==?=

    Webpart optimizations

    =?Utf-8?B?Sm9obiBHcmFudA==?=, May 2, 2006, in forum: ASP .Net
    Replies:
    3
    Views:
    1,665
    Robert Bogue [MVP]
    May 26, 2006
  2. Rob Adelberg

    switch statement optimizations

    Rob Adelberg, Sep 18, 2003, in forum: C++
    Replies:
    5
    Views:
    384
    Ron Natalie
    Sep 18, 2003
  3. Scott Robert Ladd
    Replies:
    2
    Views:
    363
    Gianni Mariani
    Nov 17, 2003
  4. zb32

    bitfield optimizations

    zb32, Jul 13, 2004, in forum: C++
    Replies:
    1
    Views:
    1,075
    David Harmon
    Jul 13, 2004
  5. Patrick Stinson
    Replies:
    3
    Views:
    337
    Patrick Stinson
    Sep 22, 2004
Loading...

Share This Page