If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > ASP Session or Db-calls

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-05-02, 07:16
Daniel Daniel is offline
Registered User
 
Join Date: Apr 2002
Posts: 6
Question ASP Session or Db-calls

Hello!

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
Reply With Quote
  #2 (permalink)  
Old 06-07-02, 14:50
Khalid Khalid is offline
Registered User
 
Join Date: Jan 2002
Location: Libya
Posts: 50
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On