Re: database connections

From: Tim (Tim.1l9u5c_at_no-mx.hjyllc.com)
Date: 03/02/05 

Date: Wed, 2 Mar 2005 08:43:25 -0600

With a pconnect mysql holds a session so that you are not reconnecting
each time. This works good if you are only connecting to one
database.

Warning:
There are time when pulling information from two different databases
within the same script where mysql will use the same session and try to
pull them all from one table. 

-- 
Tim
------------------------------------------------------------------------
Tim's Profile: http://www.hjyllc.com/forums/member.php?userid=1
View this thread: http://www.hjyllc.com/forums/showthread.php?t=6808

Relevant Pages

  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Retrieving state information from a middle tier
    ... Now this very first call can make session root entry into an xml file like ... We have a middle tier which is made up ... > The current implementation only allows for one database to be served up. ... > longer use the middle tier as the source of the connection properties. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Horizontal scaling - advice needed
    ... the session can be unambiguously proxied to the right backend server, ... To start with have a single database machine. ... Full database clustering is challenging, but if your site is making you lots ... For transient session state, ...
    (comp.lang.ruby)
  • Re: VirtualPathProvider and Application Restart
    ... the session state to the Database Server and move a lot of lightweight ... to unload it from the AppDomain. ... When you update an ASPX file, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: form to email document
    ... >> append the Session ID for that user Session to the file name. ... >> name uploaded.This can come from a simple text file or a database. ... >>> I was hoping for something like the procedure used to upload a form, ...
    (microsoft.public.frontpage.programming)