Re: Is perl better? :(((

akizub_at_yahoo.com
Date: 02/02/05

  • Next message: Joe Weinstein: "Re: Can you help me with JDBC getDate() error?" 
    Date: 1 Feb 2005 18:10:00 -0800

    Dar7yl:
    Thank for answer.
    >If your jdbc driver supports it, turn on tracing/profiling.
    I use jodbc14.jar from Oracle. Don't know how to force it to trace.
    Tomorrow will have a look on oracle.com.
    But what is the diffence where time is spent? I still have to pay the
    price.

    > if (rs.next())
    > {
    > // logic goes here
    > }
    Of course I usually do this. You can see it from previous code.
    I only tried to simplify the code and reduce number of getMilliseconds
    calls.

    >Perhaps, you could optimize the query to return the whole list in one
    call.

    Of course I do it in real project.
    And I can do it in both Java or perl.
    But then quiry eats so much power of Oracle that DBAs call me and ask
    to stop it.
    Did you ever had such experience when your query runs for hour and DBA
    call you and ask what is that query which combines 9 tables and hold
    whole system for an hour?
    What can I answer for such DBA? That this is your database structure
    and your relations? And there is no other way to obtain data from your
    imparctical design?
    And people like this design and support this system...
    So, I ask no questions.
    I ask them here :))))

    Anyway. It seems for me more and more that difference is in OCI driver
    for perl. I'll try to play with it but will take time.
    And anyway again it's rear approach. Most applications use thin driver.
    And when it three times slower then OCI... too bad.

    Thanks anyway. I already gave up.
    But it was good experience for me.
    I know a lot of new stuff and will know even more (with this OCI I
    hope).

    And project remains on perl. But who cares!
    perl is much better then COBOL.
    Another of my previous projects is still on COBOL :(((

    Alex Kizub.

  • Next message: Joe Weinstein: "Re: Can you help me with JDBC getDate() error?"

    Relevant Pages

    • Re: Is perl better? :(((
      ... I use jodbc14.jar from Oracle. ... And I can do it in both Java or perl. ... It seems for me more and more that difference is in OCI driver ... And when it three times slower then OCI... ...
      (comp.lang.java.programmer)
    • Re: oci to sql conversion?
      ... I have a component that uses the OCI library to do spatial index ... to rewrite these queries using some flavour of SQL? ... it too now) but use a more modern driver. ... Oracle offers the OLE DB and ADO ...
      (comp.databases.oracle.misc)
    • Re: Perl and Oracle
      ... Perl for Oracle DBAs ... You must be aware, however, that Perl DBI driver to work with Oracle is ... are taking on the role of lead maintainer - with my support and gratitude. ...
      (comp.databases.oracle.server)
    • Re: Is perl better? :(((
      ... > I use jodbc14.jar from Oracle. ... > And I can do it in both Java or perl. ... > Did you ever had such experience when your query runs for hour and DBA ... It seems for me more and more that difference is in OCI driver ...
      (comp.lang.java.databases)
    • Re: Is perl better? :(((
      ... > I use jodbc14.jar from Oracle. ... > And I can do it in both Java or perl. ... > Did you ever had such experience when your query runs for hour and DBA ... It seems for me more and more that difference is in OCI driver ...
      (comp.lang.java.programmer)