Re: environment variable

2007-01-22 Thread Peter J. Holzer
On 2007-01-19 12:01:29 -0800, Jonathan Leffler wrote: system(VAR=val /path/to/your/shell/script); Well, that worked nicely for me with Korn Shell (and would work with Bourne Shell), but won't work with C shell (again). On Unix-like systems the system() function always invokes /bin/sh, not

Re: DBD::Oracle: Row cache fetch ahead on cursor returned from PL/SQL stored proc?

2007-01-22 Thread Charles Jardine
On 19/01/07 18:07, Joel Noble wrote: Hello, all! I'm having slow performance reading from a cursor that is returned from a stored procedure. Network tracing and strace confirms that a round-trip is being done to the Oracle DB to fetch each row, with no pre-caching. Using DBI-1.52,

Re: patches available for DBD::Multi, and benchmarking results

2007-01-22 Thread Henri Asseily
On Jan 20, 2007, at 12:29 AM, Mark Stosberg wrote: Some other folks may be interested in the patches I've published for DBD::Multi recently: http://rt.cpan.org/Public/Dist/Display.html?Name=DBD-Multi Perhaps most interesting might be a benchmarking script I made, and related optimization

about dbi building error.

2007-01-22 Thread Nancy Ni
Dear Sir./Ms. My current server perl version is: This is perl, version 5.005_03 built for sun4-solaris The Bundle about DBI I using is DBI-1.37. During building it,there is some error appearing: sunbilldev% make /bin/sh -c true /bin/sh -c true /bin/sh -c true cc -c -xO3

Re: patches available for DBD::Multi, and benchmarking results

2007-01-22 Thread Mark Stosberg
Henri, Thanks again for another prompt and extremely helpful response. Henri Asseily wrote: I humbly repeat my earlier suggestion to use DBIx::HA. I'm going to try it again today, using the same benchmark system. I'll report back the results. I started looking at DBD::Multi again because it

Re: about dbi building error.

2007-01-22 Thread Michael Nhan
Hi, If you choose to use the sun compilers to compile DBI, you must install the sun compilers. Sun does not come with the compilers preinstalled. That's why you are getting /usr/ucb/cc: language optional software package not installed. Have your sys-admin install the Forte CC compilers

Re: patches available for DBD::Multi, and benchmarking results

2007-01-22 Thread Mark Stosberg
I expanded by benchmark of DBD::Multi to also include DBIx::HA for comparison. While the benchmark reported nearly a 200% overhead for DBD::Multi, the overhead of DBIx::HA was much better, reported at 50%. That sounds like a lot in both cases, but is not necessarily. First, my test case is not