Initial ROP client query takes way to long

From: Zissis Trabaris (z.trabari..nsysware.com)
Date: Fri Jun 05 2009 - 05:35:43 EDT

  • Next message: Zissis Trabaris: "RE: [jira] Resolved: (CAY-1167) Create model schema XSD"

    Here is the scenario ... We have a database with over 121,000 tables
    mapped in cayenne running under an out of the box ROP client server
    model. After the client creates the connection, it authenticates the
    user by querying the user table (that table only currently has about 6
    rows in it). The initial query always takes about 30 seconds and then
    everything is fine on subsequent queries. I am wondering if something is
    going on with the first ROP client query. Is the client trying to cache
    the server's entity resolver data set?? Or is it something else? Is
    there any way to speed up the initial client query?

     

    Zissis Trabaris * Chief Technology Officer * INSYSWARE * 3235 West River
    Road, Grand Island, New York, 14072, USA
    Mobile (716) 930-5654 * Office (518) 636-4118 * Fax (716) 625-1305 *
    z.trabari..nsysware.com <mailto:%20%20z.trabaris@insysware.com> *
    www.insysware.com <http://www.insysware.com/>

    ________________________________

    CONFIDENTIALITY: This email (including any attachments) may contain
    confidential, proprietary and privileged information, and unauthorized
    disclosure or use is prohibited. If you received this email in error,
    please notify the sender and delete this email from your system. Thank
    you.

     

    This archive was generated by hypermail 2.0.0 : Fri Jun 05 2009 - 05:23:37 EDT