Re: DBD::Oracle question

From: Tim Bunce (Tim.Bunce_at_pobox.com)
Date: 11/18/04

  • Next message: Tim Bunce: "Re: No Values (in $sth->execute call)" 
    Date: Thu, 18 Nov 2004 00:21:14 +0000
To: Giovanni Borri <gborri@libero.it>

    Make sure your statement handles are being destroyed
    as soon as they're not needed.

    Using prepare_cached() is one possible cause of long-lived
    statement handles.

    print $dbh->{Kids} will tell you how many statement handles
    exist for a given database handle.

    Tim.

    On Wed, Nov 17, 2004 at 06:16:16PM +0100, Giovanni Borri wrote:
    > hi Tim,
    >
    > I have a question for you about the use of DBD::Oracle library.
    > It's almost 3/4 years that we are using your library to connect to Oracle
    > database. I this days we are facing a problem and i don't know if it is a
    > problem of the library or what.
    > What seems to happen is that when we open a connection to the database and run
    > some query, after a number of query that we have run seems that we fill the
    > number of possible cursor per connection. The workaround we have used to not
    > facing the problem is to open the connection, run a defined number of query
    > and then close the connection. However this workaround affect the performance
    > of the database.
    > Can you please let me know.
    >
    > Thanks in advance
    > Giovanni
    >
    >

  • Next message: Tim Bunce: "Re: No Values (in $sth->execute call)"

    Relevant Pages

    • Re: Ada DB bindings and APQ
      ... >>I didn't like the use of handles for database objects. ... > will ensure that the connection will not go away until at least one query ... > things which can be made with a connection. ... That is different to ODBC. ...
      (comp.lang.ada)
    • RE: Posible to speed up query update with Apllication.screenupdati
      ... Don't change anything on the database side; the only question is the most ... You create a connection by sending the connect string to the ODBC driver. ... (multiple queries). ... You now execute the query (there are several ways in ADO but I usually ...
      (microsoft.public.excel.programming)
    • Re: MS Access looks for .mdb rather than Progress schema
      ... It got past looking for pub.mdb, and looks like it tried to run the query ... I also tried putting the whole thing in the connection string: ... The settings for the Merant ODBC driver for ... default connect string means a jet database. ...
      (microsoft.public.access.modulesdaovba)
    • Re: Word 2003 Closes upon update of sort order of table using Acce
      ... data connection file created to the database folder and created a dummy user ... connection is much faster and seems far more stable. ... incorporate OLE DB, they probably found themselves with a lot more problems ... embed a table or query name. ...
      (microsoft.public.word.mailmerge.fields)
    • Sql Server SCOPE_IDENTITY()
      ... I'm currenly in the process of writing a Database abstraction class ... SCOPE_IDENTITY query it is on the same connection as the INSERT query (which ...
      (microsoft.public.dotnet.framework.adonet)