Installing Oracle (was: DBD::*-bind_param() ?)

2001-04-30 Thread Robin Houston
On Fri, Apr 27, 2001 at 11:31:16PM +0100, David Cantrell wrote: Does anyone? Every time I've used Oracle, it's been installed by someone else who was supposedly an expert. Although I remain to be convinced that any of them really *was* an expert. I've installed Oracle a few times, and I'm

Re: DBD::*-bind_param() ?

2001-04-29 Thread Jonathan Stowe
On Sat, 28 Apr 2001, Simon Cozens wrote: On Fri, Apr 27, 2001 at 12:16:32PM -0700, Paul Makepeace wrote: Clearly says someone who's hasn't installed Oracle recently! You can install Oracle now? Wow, they must have really been fixing it of late. Great. They keep sending me the 9i suite

DBD::*-bind_param() ?

2001-04-27 Thread Paul Makepeace
Seems like DBD::Pg and mysql both support bind_param().. but do they really? Checking mysql API docs seems to suggest (unless I'm looking at the beginner version) there aren't any functions to prepare statements. I haven't looked at Postgres. Can anyone confirm/deny? Ah ha! (answering my own

Re: DBD::*-bind_param() ?

2001-04-27 Thread Roger Burton West
On or about Fri, Apr 27, 2001 at 01:46:16AM -0700, Paul Makepeace typed: Does anyone have any Real World experience with the speed-up (even hand-wavy vague anecdotes) of using bind values v. reparsing the SQL each time (for databases that support this obviously). Postgres and Oracle I'm

Re: DBD::*-bind_param() ?

2001-04-27 Thread Paul Makepeace
On Fri, Apr 27, 2001 at 09:49:33AM +0100, Roger Burton West wrote: Oracle quite a bit - it parses the statement with placeholders and does large amounts of cacheing. Definitely worth it if you're fiddling with large dbs. For postgres it's a lot less important IME. Great, thanks! This is all

Re: DBD::*-bind_param() ?

2001-04-27 Thread Leon Brocard
Paul Makepeace sent the following bits through the ether: Does anyone have any Real World experience with the speed-up (even hand-wavy vague anecdotes) of using bind values v. reparsing the SQL each time (for databases that support this obviously). Postgres and Oracle I'm particularly

Re: DBD::*-bind_param() ?

2001-04-27 Thread Paul Makepeace
On Fri, Apr 27, 2001 at 11:45:40AM +0100, Leon Brocard wrote: It helps a lot (and is also blindingly easy to benchmark yourself ;-). Clearly says someone who's hasn't installed Oracle recently! [This is after all the point of community lists is to ask questions of others who've already done it

Re: DBD::*-bind_param() ?

2001-04-27 Thread David Cantrell
On Fri, Apr 27, 2001 at 12:16:32PM -0700, Paul Makepeace wrote: On Fri, Apr 27, 2001 at 11:45:40AM +0100, Leon Brocard wrote: It helps a lot (and is also blindingly easy to benchmark yourself ;-). Clearly says someone who's hasn't installed Oracle recently! Does anyone? Every time I've

Re: DBD::*-bind_param() ?

2001-04-27 Thread Paul Makepeace
On Fri, Apr 27, 2001 at 11:31:16PM +0100, David Cantrell wrote: On Fri, Apr 27, 2001 at 12:16:32PM -0700, Paul Makepeace wrote: On Fri, Apr 27, 2001 at 11:45:40AM +0100, Leon Brocard wrote: It helps a lot (and is also blindingly easy to benchmark yourself ;-). Clearly says someone

Re: DBD::*-bind_param() ?

2001-04-27 Thread Simon Cozens
On Fri, Apr 27, 2001 at 12:16:32PM -0700, Paul Makepeace wrote: Clearly says someone who's hasn't installed Oracle recently! You can install Oracle now? Wow, they must have really been fixing it of late. -- If the code and the comments disagree, then both are probably wrong.

Re: DBD::*-bind_param() ?

2001-04-27 Thread Paul Makepeace
On Sat, Apr 28, 2001 at 12:09:49AM +0100, Simon Cozens wrote: On Fri, Apr 27, 2001 at 12:16:32PM -0700, Paul Makepeace wrote: Clearly says someone who's hasn't installed Oracle recently! You can install Oracle now? Wow, they must have really been fixing it of late. OK, so I cheated, and