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 * [email protected] <mailto:%20%[email protected]> * 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.
