Darren Duncan wrote:
Okay, considering that using the same name prepare() like this may
confuse some people, here is a refined solution that uses 3 methods
instead; please disregard any contrary statements that I previously made:
I think I'm beginning to like it.
Allow me to suggest one or
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
4. All host parameters should be named (like :foo) rather than
positional (like ?), meeting with the SQL:2003 standard. The named
format is a lot easier to use and flexible, making programmers a lot
less error prone, more powerful, and particularly more resource
efficient when the same
At 6:14 PM +1200 7/5/05, Sam Vilain wrote:
I think I'm beginning to like it.
Allow me to suggest one or two further refinements...
my $sth1 = $dbh.compile( $sql_or_ast ); # always sans connection
$sth1.prepare(); # always with connection, even if DBD doesn't use it
$sth1.execute(); #
Sam Vilain wrote:
However, making it in a file in $HOME/.xxx means that the sysadmin can
set it up to be mode 400 or something like that, to ensure other users
can't access it if someone forgot to set the permissions right on the
application code (or, hopefully, configuration file).
I don't
- optional treatment of the statements as an AST, similar in concept to
SQL::Routine, or Tangram::Expr. Death to SQL templating systems!
I suspect during this process people are going to want a lot of things
that layer on top of what we currently see as DBI.
Personally I think Tim got
Sam Tregar [mailto:[EMAIL PROTECTED] wrote:
I didn't mean to imply that asking for money was a bad idea. I think
it's a fine idea. I just didn't think that was the main point of the
email. Here's the message I got from that email:
There's a new project starting that needs help. I
Nobody ever claimed Perl is faster than C. Just more appropriate for
certain kinds of jobs.
Have you tried setting $dbh-RowCacheSize? This can make a big different in
bulk data operations.
-Will
-Original Message-
From: Gerardo Santana Gómez Garrido [mailto:[EMAIL PROTECTED]
Sent:
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
Hello,
I have a small-but-weird problem. When I install the 0.34 release of
DBD::File via CPAN it seems to make/test/install properly but... it just
doesn't stick. The installation seems to stay at 0.33. I also get when I
download directly and do the make/test/install myself. Here's the
oracle 9.2.0.4 (client)
DBD-Oracle 1.16
DBI 1.40
Apache DBI 0.94
Perl 5.8.5
We recently moved from the web server and DB running on the same
machine to two seperate machines. Things started smoothly, but over
the weekend, we have seen some weirdness and really can't explain why
things work
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
Paul,
Did you check the timestamp of the new .pm and/or .so? Maybe the internal
$VERSION variable was not updated by the module author.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Paul Boutros [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 05,
On Tue, 5 Jul 2005, Ronald J Kimball wrote:
Total Contributions: $1320.25
I suggest you go back and reread Tim's email. What he said was that he
donated a little over $500 himself, not that the total raised was $500.
That's good to know. It doesn't really alter my assessment though -
the
Adam Kennedy wrote:
Yes, native positional support is still important.
positions make it very easy to do SQL math.
To express it in overly simplistic code
$foo = [ a = ?, foo ];
$bar = [ b = ?, bar ];
$baz = $foo and $bar;
# $baz now is [ a = ? and b = ?, foo, bar ];
Bearing mind a situation
On Tue, 5 Jul 2005 11:33:00 -0600, Reidy, Ron wrote:
Hi Folks
Or perhaps the old version is in the path before the new version.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 6/07/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
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.
On 7/2/05, Dean Arnold [EMAIL PROTECTED] wrote:
- Asynchronous queries (coroutines? threads?)
Threads. If you've ever done much Java/JDBC work, you'll
realize how much simpler a solution to async it is.
(Ignoring the rest of Java/JDBC's undesirable traits)
A couple quarters ago I
On 7/5/05, Dean Arnold [EMAIL PROTECTED] wrote:
I'm already implementing [a message-passing async] wrapper for DBI
(DBIx::Threaded); not a pragma, and very specific to DBIv1, but hopefully it
solves
at least 85-90% of the problem. (tho async cancel/abort isn't
solvable at this point)
Maxim Sloyko wrote:
I don't think this solves the problem, because what I usually want is
the user to be able to use the application, but unable to see the DB
password. So the user should have read permission set for the file,
but on the other hand he shouldn't. It's not not a problem for Web
20 matches
Mail list logo