Re: Connection String

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Marina (someone_at_nospam.com)
Date: 03/04/04 

Date: Thu, 4 Mar 2004 14:57:08 -0500

The only reason would be to not have to decrypt it every time, since it's
being stored encrypted. Besides, even if it was being stored in plain text,
do you think one string the size of a connection string would take up enough
memory for it to actually make a difference? If the memory performance of
an application is ruined by having a connection string in memory at all
times, then there are real problems...

"Stanley" <webmaster@nospam-glass-images.com> wrote in message
news:O8o$UIiAEHA.3352@TK2MSFTNGP09.phx.gbl...
> Why do you want it in memory? You can grab it anytime you want from your
> web.config. Putting it in memory just means less memory for other things.
> Just my opinion here but I like to save the memory for more important
> things.
>
> -Stanley
>
> "A.M" <IHateSpam@sapm123.com> wrote in message
> news:eUu51EiAEHA.1700@TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I have an encrypted database connection string stored in web.config file
> and
> > i need to have the connection string several times in my application.
> >
> > What would be the best way to have that connection string in memory
> variable
> > ?
> >
> > I am thinking to add a member variable to Global class in global.aspx.cs
> and
> > initialize it in Application_Start event handler. Is it the best
practice?
> >
> > Thanks,
> > Ali
> >
> >
>
>

Relevant Pages

  • TADOClientDataset?
    ... TADODataset at run-time, and all in memory. ... I'm currently using TClientDataset to create an in-memory dataset, ... "missing connection or connection string". ...
    (borland.public.delphi.database.ado)
  • Re: Best practices
    ... Some people use a dataset to make a copy of all the data in memory, then they don't succeed and show their failures by saying things like you have heard and go back to the old simulating punch card systems on disk they were used to. ... About the memory, be aware that OOP programming is not anymore using principles of 1980, it is for sure spending more memory. ... Into a form I´ve made my connection string and my SqlConnection variable. ... I read a lof ot tutorials but each of show a differente manner and opinion. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Command Strings per Application
    ... one application, per 1 connection string? ... ridiculously high that you'll never hit it. ... And I'd even have to question "available memory" since Windows will just use ...
    (microsoft.public.vb.general.discussion)
  • Re: Connection String
    ... You can grab it anytime you want from your ... Putting it in memory just means less memory for other things. ... > i need to have the connection string several times in my application. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: hiding global variables
    ... because you may be placing the security fence at the ... I presume then you are operating a scheme whereby the user enters a password which is used to decrypt a public-key which is then used to decrypt the database?That way, the program itself doesn't contain enough information to decrypt the data, until the password is entered. ... In general, this will be easier to achieve in C, where you can control memory more closely, and can avoid introspection. ... generate an individual key-file by encrypting the public key from with their password. ...
    (comp.lang.tcl)