I have some reporting requirements that are experiencing performance/load issues, when aggregating data using EO objects and transversing all their relationships. To solve this I have created a MYSQL view which 'flattens' the data structure and executes very quickly, [and should go some way to fixing the performance issues].
I am struggling to figure out how to create and bind a 'read-only' entity in the eclipse Entity-Modeller perspective, to my database VIEW. Is this possible [and where do I find the appropriate documentation], OR do I have to use a raw rows query on the VIEW directly? From a maintenance perspective I would rather use Entities than raw row queries [that are buried in the code]. I use eclipse 3.3.2 running Wolips, using the WebObjects Framework (non-wonder) 5.3. Regards George Wiles | Software Development TXT2GET | P +64 4 384 1438 | M +64 27 2758 143 Level 5, 75 Ghuznee Street, Wellington, New Zealand <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]| <http://www.txt2get.co.nz/> www.txt2get.co.nz
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
