Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002

    Question Unanswered: ASP Session or Db-calls


    What will give me the best performance?
    On Session_onStart calling my Db and fetching all the data I need and then just refer to these recordsets throughout the whole session using the filter prperty to filter out the data I need
    or is it it better to just call the Db evertime I need the data?

    Grateful for any answer
    Daniel Martinsson

  2. #2
    Join Date
    Jan 2002
    I think you should call your records every time a page is requested, because ASP is cookies based.
    The session it self is nothing but a cookies generated when a session starts, and a unique random number is generated to identify the client's session variables.

    Now, if ASP is going to do the same process for you every time, I suggest not trusting it, and do you work every time.

    This is my personal opnion and I am using it.

    Remember to destroy every object you create.

    Hope this helps
    Khalid Yousef

Posting Permissions

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