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
email@hidden|
www.txt2get.co.nz