Correct - the first ROP access causes client to load all the mapping
metadata from the server. I guess the sheer # of tables in your schema
causes such a delay. To avoid slow bootstrap theoretically it should
be possible to persist the mapping on the client with some coding
effort, however this ability does not exist in Cayenne as of now.
Another thing is to make sure that the server is "warmed up" when the
first client connects, as the server overhead of loading mapping for
121000 entities and then converting them to client counterparts may be
noticeable. So maybe call something like this on server startup:
getDomain().getEntityResolver().getClientEntityResolver()
Andrus
On Jun 5, 2009, at 12:35 PM, Zissis Trabaris wrote:
> 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 - 07:49:11 EDT