This is a discussion on Is perl better? :((( - Framework and Interface Programming ; Dimitri Maziuk wrote: > > Lee Fesperman sez: > ... > > At least with JDBC, much of this can be covered with defensive programming. > > Have you ever written a JDBC application intended to run with a variety ...
Re: Is perl better? :((( Dimitri Maziuk wrote:
>
> Lee Fesperman sez:
> ...
> > At least with JDBC, much of this can be covered with defensive programming.
> > Have you ever written a JDBC application intended to run with a variety of
> > drivers and backends? I have (several in fact). It is possible to get
> > reasonable coverage if you're careful. The situation with SQL is much worse.
> > Everyone has their own proprietary version of the language.
>
> I love how Oracle's thin driver doesn't have
> DatabaseMetadata.getDatabaseXXXVersion(). So that you can't do
> if( version >= 10 ) stat.executeUpdate( "drop table foo purge" );
> else stat.executeUpdate( "drop table foo" );
> without a pattern match on the product name string.
> Hatess 'em, we doess...
Interesting. What does "drop table foo purge" mean?
--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)
Re: Is perl better? :((( Luke Webber wrote:
> Tor Iver Wilhelmsen wrote:
>
>> Dimitri Maziuk <dima@127.0.0.1> writes:
>>
>>
>>> JVM startup time and garbage collection.
>>
>>
>>
>> Perl has (in theory at least) both of those as well, though.
>
>
> And we're talking about a process that runs for as much as ten minutes,
> so it should not be significant.
Since he's creating/deleting all the time (probably), it might well be.
Re: Is perl better? :((( Lee Fesperman sez:
....
> Interesting. What does "drop table foo purge" mean?
It doesn't delete tables anymore, it renames them to
RECYCLEQWJQ#(*$@!#JR.BIN instead. "Purge" means
"don't clutter my tablespace with junk, I really mean
to delete the fscking thing and I know what I'm doing".
Dima
--
Tlaloc: What was Elrond's second name?
Gruber: Hubbard -- <ahbou=3C69EB63.A7C431F4@last.com>
Re: Is perl better? :((( Dimitri Maziuk wrote:
>
> Lee Fesperman sez:
> ...
> > Interesting. What does "drop table foo purge" mean?
>
> It doesn't delete tables anymore, it renames them to
> RECYCLEQWJQ#(*$@!#JR.BIN instead. "Purge" means
> "don't clutter my tablespace with junk, I really mean
> to delete the fscking thing and I know what I'm doing".
Thanks for the explanation. The 800 pound gorilla at work again ;^)
--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)
Re: Is perl better? :((( akizub@yahoo.com wrote:
> Profile doesn't have sense for me. It's obvious.
There is no such thing as obvious.
Post code that compiles and runs or you'll find that help dries up
pretty damn fast.
Profilers are there for a reason : one such as yours.
Re: Is perl better? :((( dar7yl wrote:
> "Robert Klemme" <bob.news@gmx.net> wrote in message
> news:3673qgF4uqtk7U1@individual.net...
>
>>Apparently not. I suggest you post code that compiles and is properly
>>indented.
>
>
> What is your definition of "properly indented"?
> Do you mean that hideous "K&R" standard of placing the brace
> at the end of the line?
Which makes perfect sense since blocks of code are bordered by only two
border - much more easy to see than three lines:
void NoItsNot(){
while(int i=0;i<10{
// blah
// blah
i++;
}
}
>
> void myMethodIsBetterThanYours()
> // a light-hearted dig at the style wars...
> {
> if ( youThinkYoursIsBetter() )
> {
> // flame wars begin ...
> }
> }
> regards,
> Dar7yl.
>
>
--
Walter Mitty
-
Useless, waste of money research of the day : http://tinyurl.com/3tdeu
" Format wars could 'confuse users'"
http://www.tinyurl.com
Re: Is perl better? :((( On 31 Jan 2005 20:31:59 -0800, akizub@yahoo.com wrote:
> con = DriverManager.getConnection(url, user, password);
[...]
> And here is perl code:
> ################# perl ########################
> #!/perl/5.6/bin/perl
> use lib "/perl/5.6/DBD/oracle8.1.6/lib/site_perl/5.6.0/sun4-solaris";
> use Oraperl;
How does Perl connect to Oracle? If it's not via a socket using
TCP/IP but a named pipe or using shared libs communicating "directly"
with the database there is no sense in comparison. The profile you
posted shows that the majority of computer-power was spent for
communication via the socket.
> ... open connection ....
This part would be the interesting part for answering the question.
Regards, Lothar
--
Lothar Kimmeringer E-Mail: spamfang@kimmeringer.de
PGP-encrypted mails preferred (Key-ID: 0x8BC3CD81)
Always remember: The answer is forty-two, there can only be wrong
questions!
LinkBack URL
About LinkBacks