Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Build connection on every page?

Reply
Thread Tools

Build connection on every page?

 
 
Stijn Verrept
Guest
Posts: n/a
 
      01-20-2004
When I do a Response.Redirect to load another page do I need to connect
to the database again if I need information? If so, isn't this a bad
for performance?


--
Kind regards,

Stijn Verrept.
 
Reply With Quote
 
 
 
 
Hermit Dave
Guest
Posts: n/a
 
      01-20-2004
depends on the application and the amount of data you fetch with each call.
by default a pool of 100 objects is maintained.. ie if you create a
connection and then called dispose.. its returned to connection pool...
if then you do another request and if that object is not being used... it
will be served to you.. otherwise a new object is created...
if you are fetching large amounts of data with each call.. and you
frequently call same set of db calls... then it might be a better idea to
use
a: cache is the data is common but frequently used between users
b: session if the data is unique but frequently used (if you state piling up
data in session it may cause application restart to reduce memory usage)
at the end of it... you do have to do a comparitive performance in terms of
memory usuage and making the db call..

hope this helps..

--
Regards,
HD
Once a Geek.... Always a Geek
"Stijn Verrept" <stijn@no_s.p.a.n.entrysoft.com> wrote in message
news:400c7d8f$0$295$(E-Mail Removed)...
> When I do a Response.Redirect to load another page do I need to connect
> to the database again if I need information? If so, isn't this a bad
> for performance?
>
>
> --
> Kind regards,
>
> Stijn Verrept.



 
Reply With Quote
 
 
 
 
Stijn Verrept
Guest
Posts: n/a
 
      01-20-2004
Hermit Dave wrote:

> a: cache is the data is common but frequently used between users
> b: session if the data is unique but frequently used (if you state
> piling up data in session it may cause application restart to reduce
> memory usage) at the end of it... you do have to do a comparitive
> performance in terms of memory usuage and making the db call..
>
> hope this helps..


Thanks, this sure helps. I searched MS for pooling and found a good
article about it as well.

--
Kind regards,

Stijn Verrept.
 
Reply With Quote
 
 
 
Reply

Thread Tools

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 Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Explorer.exe error report every time access every type of video me =?Utf-8?B?SXJ3YW5zeWFo?= ASP .Net 4 10-30-2007 07:49 AM
Build a Better Blair (like Build a Better Bush, only better) Kenny Computer Support 0 05-06-2005 04:50 AM
Build with every change to the code?!?!? David Lozzi ASP .Net 4 12-16-2004 05:52 AM
SWsoft Acronis Disk Director Suite 9.0 Build 508, Acronis OS Selector 8.0 Build 917, Acronis Partition Expert 2003 Build 292, Acronis Power Utilities 2004 Build 502, F-SECURE.ANTI vIRUS.PROXY v1.10.17.WINALL, F-SECURE.ANTI vIRUS v5.50.10260 for CITRI vvcd Computer Support 0 09-25-2004 01:38 AM
How to build ASP.NET projects on a separate build machine? Vagif Abilov ASP .Net 2 07-07-2004 04:34 PM



Advertisments