caching table data

Discussion in 'ASP General' started by Justin, Aug 16, 2004.

  1. Justin

    Justin Guest

    I'm involved in this localization project, and part of the process is
    taking the english content out of the pages and storing them in the db
    as key/value pairs (which we call tokens).

    Would be any performance problem if all of the tokens were stored in
    one table, for each language. Say there’s 1000 Tokens, and there’s 50
    languages supported, then that would be 50000 entries. It's hard to
    guess how long each string will be... Ok, that’s not very big, but
    what if we were to load that up in the application scope, so it would
    be easily accessible (maybe in a dictionary object for each locale).
    Do you forsee any problems in that? Or does ASP offer some other
    caching mechanism for this?

    As always, TIA
     
    Justin, Aug 16, 2004
    #1
    1. Advertising

  2. 50000 rows is nothing for a SQL Server database to handle. Queries should
    be efficient as well, given proper indexing techniques.

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




    "Justin" <ng@NO_SPAMmaritimeNO_SPAMsource.ca> wrote in message
    news:...
    > I'm involved in this localization project, and part of the process is
    > taking the english content out of the pages and storing them in the db
    > as key/value pairs (which we call tokens).
    >
    > Would be any performance problem if all of the tokens were stored in
    > one table, for each language. Say there’s 1000 Tokens, and there’s 50
    > languages supported, then that would be 50000 entries. It's hard to
    > guess how long each string will be... Ok, that’s not very big, but
    > what if we were to load that up in the application scope, so it would
    > be easily accessible (maybe in a dictionary object for each locale).
    > Do you forsee any problems in that? Or does ASP offer some other
    > caching mechanism for this?
    >
    > As always, TIA
     
    Aaron [SQL Server MVP], Aug 16, 2004
    #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. Hypo
    Replies:
    6
    Views:
    424
  2. Troy Simpson

    Fragment Caching inside page caching?

    Troy Simpson, Jan 19, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    806
    Troy Simpson
    Jan 19, 2004
  3. Rio
    Replies:
    4
    Views:
    1,202
  4. JimLad
    Replies:
    3
    Views:
    926
    JimLad
    Jan 21, 2010
  5. nullref

    data grid - data caching help

    nullref, Dec 7, 2005, in forum: ASP .Net Web Controls
    Replies:
    0
    Views:
    124
    nullref
    Dec 7, 2005
Loading...

Share This Page