prepare() - Mailing list pgsql-general

From Tom Allison
Subject prepare()
Date
Msg-id 51762686-B75E-4B2F-8425-38C0BA06DEE4@tacocat.net
Whole thread Raw
Responses Re: prepare()
List pgsql-general
Is there an advantage to using something like $dbh->prepare($sql) if
the SQL is going to be run once within the scope of the code?  The
code block may be run many times in a minute as in a function call ---

while (<>) {
    insert_something($_);
}

Will the prepare statement be cached @ the database even if it's
destroyed in the code/application?

pgsql-general by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: monitor stats
Next
From: Naz Gassiep
Date:
Subject: TimeZone List