The Cayenne Modeler can't handle it. Hence, we created our own MDA modeling environment that can :) I have stress tested the environment to upwards of 500,000 tables and impressively the cayenne ROP runtime works flawlessly. Of course we have to use our own modeler in design time. Since we created our own modeler we are also benefiting from a few things that the cayenne modeler does not do such as a tree view representation of tables so that you can visual manage table and object relationships.
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] * 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. -----Original Message----- From: Aristedes Maniatis [mailto:[email protected]] Sent: Friday, June 05, 2009 9:52 AM To: [email protected] Subject: Re: Initial ROP client query takes way to long On 5/6/09 11:20 PM, Zissis Trabaris wrote: > We are using HTTPS and I don't believe this will work over SSL > connections. It would also add a significant overhead since it will > compress every request and every payload. The compression happens first and then SSL is applied on top, so it is perfectly possible to use both. > 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. I am absolutely stunned. How do you manage such a database structure? I can only imagine that Cayenne Modeler runs out of RAM. Ari Maniatis
