[GENERAL] prepare()

[Tom Allison]

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?

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings