RE: SelectQuery and table that is synonym

From: McDaniel, Joe R. (mcdanij..igr.ORG)
Date: Fri Jul 08 2005 - 14:11:46 EDT

  • Next message: Joseph Hannon: "How do I use the Modeler to define a non key field as unique?"

    There is a significant difference in time to execute for these
    "identical" queries. Have you tried the two queries directly using some
    database utility?

    Also, Oracle's JDeveloper is now free and is a superb IDE which has
    database browsing built-in. It is not Oracle specific for database,
    J2EE, or anything. For the price, it beats Eclipse every-which-way in my
    opinion. I have used it with Cayenne for debugging and testing -- you
    just create a library entry for cayenne.jar that also points to the
    source to debug into Cayenne.

    Best,

    Joe

     

    -----Original Message-----
    From: laila paganelli [mailto:laila.paganell..mail.com]
    Sent: Friday, July 08, 2005 11:28 AM
    To: cayenne-use..bjectstyle.org
    Subject: Re: SelectQuery and table that is synonym

    TEST 3 -------------------
    INFO QueryLogger: === returned 1 row. - took 493 ms.

    TEST 4 --------------------
    INFO QueryLogger: === returned 1 row. - took 148 ms.

    This archive was generated by hypermail 2.0.0 : Fri Jul 08 2005 - 14:11:47 EDT