Re: it works, but...

2005-07-05 Thread Gerardo Santana Gómez Garrido
On 7/4/05, Jonathan Leffler [EMAIL PROTECTED] wrote: Dear Gerardo, Perl + DBI + DBD::Informix imposes at least a moderate amount of overhead compared with a raw ESQL/C program. Of course, it's reasonable, I'm aware of that. Whether the time ratio you are seeing is reasonable is slightly

RE: it works, but...

2005-07-05 Thread Rutherdale, Will
: Monday 04 July 2005 20:08 To: Jonathan Leffler Cc: dbi-users@perl.org; [EMAIL PROTECTED] Subject: Re: it works, but... On 7/4/05, Jonathan Leffler [EMAIL PROTECTED] wrote: Dear Gerardo, Perl + DBI + DBD::Informix imposes at least a moderate amount of overhead compared with a raw ESQL/C

Re: it works, but...

2005-07-05 Thread Jared Still
On Mon, 2005-07-04 at 17:08, Gerardo Santana Gómez Garrido wrote: OK, let's see what I can do. Just taking time from the project to think of rewriting reports is already a luxury, and there's a competing alternative called SQR. I have to test it too and see how much time it takes. Funny, I

Re: it works, but...

2005-07-05 Thread Gerardo Santana Gómez Garrido
On 7/5/05, Jared Still [EMAIL PROTECTED] wrote: On Mon, 2005-07-04 at 17:08, Gerardo Santana Gómez Garrido wrote: OK, let's see what I can do. Just taking time from the project to think of rewriting reports is already a luxury, and there's a competing alternative called SQR. I have to

RE: it works, but...

2005-07-05 Thread Jonathan Leffler
RowCacheSize won't have any affect on DBD::Informix unless DBI itself makes it do so. -Original Message- From: Rutherdale, Will [EMAIL PROTECTED] Sent: Jul 5, 2005 7:50 AM To: dbi-users@perl.org, [EMAIL PROTECTED] Subject: RE: it works, but... Nobody ever claimed Perl is faster than C

Re: it works, but...

2005-07-04 Thread Jonathan Leffler
Dear Gerardo, Perl + DBI + DBD::Informix imposes at least a moderate amount of overhead compared with a raw ESQL/C program. Whether the time ratio you are seeing is reasonable is slightly more debatable, but I would expect the Perl combination to be slower. The big question for you is is it

RE: DBI works, but CGI + DBI bombs?

2002-05-17 Thread Jonathan Gines
Stephen, I have implemented the below logic from you, and it has at least shed alot of light on what my Apache webserver CGI environment sees. Although, I am fairly literate with DBI (specifically DBD::Sybase), unfortunately I'm not familiar enough with CGI to know which system variable is

RE: DBI works, but CGI + DBI bombs?

2002-05-17 Thread NYIMI Jose (BMB)
cgi-list or beginners-cgi At http://lists.perl.org/ José. -Original Message- From: Jonathan Gines [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:21 AM To: Stephen Keller; [EMAIL PROTECTED] Subject: RE: DBI works, but CGI + DBI bombs? Stephen, I have implemented

Re: DBI works, but CGI + DBI bombs?

2002-05-17 Thread Jonathan Gines
Michael, Thanks!! That did the trick! v/r, Jonathan At 04:01 PM 5/16/02 -0700, Michael Peppler wrote: On Thu, 2002-05-16 at 13:59, Jonathan Gines wrote: Hello, I have 2 scripts below, where DBI is used in the former and DBI and CGI is used in the latter. The first script connects fine

Re: DBI works, but CGI + DBI bombs?

2002-05-16 Thread Michael A Chase
On Thu, 16 May 2002 16:59:15 -0400 Jonathan Gines [EMAIL PROTECTED] wrote: I have 2 scripts below, where DBI is used in the former and DBI and CGI is used in the latter. The first script connects fine via command line, and the latter fails to connect, but using the same DBI code from the

RE: DBI works, but CGI + DBI bombs?

2002-05-16 Thread Stephen Keller
I've intermixed DBI.pm (connecting to DB2) and CGI.pm a lot, so I'm pretty sure there is no name conflict between the two. One problem, I've run into frequently, however, is that the configuration of the account when running from the web server is sometimes deliberately limited. One way that

RE: DBI works, but CGI + DBI bombs?

2002-05-16 Thread Jonathan Gines
The account is able to access the database given the same args in DBI-connect. I have written several CGI programs and lots of DBI programs, but this is the first script using DBI and CGI together, where either CGI works (using CGI.pm and instances created from CGI.pm), or DBI works via

Re: DBI works, but CGI + DBI bombs?

2002-05-16 Thread Michael Peppler
On Thu, 2002-05-16 at 13:59, Jonathan Gines wrote: Hello, I have 2 scripts below, where DBI is used in the former and DBI and CGI is used in the latter. The first script connects fine via command line, and the latter fails to connect, but using the same DBI code from the former. I'm

RE: ODBC works from command line but not from perl?

2001-04-26 Thread Sterin, Ilya
Are you sure that you $dsn is getting the correct value, you might want to print it out to see if any other value is being used. Ilya Sterin -Original Message- From: Jack McKinney [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 1:11 PM To: [EMAIL PROTECTED] Subject: ODBC works