It's too long since I don't work on app-schema as to even try to respond your previous questions... > As a final note, is there any plan to try alternative strategies to improve > the > feature chaining approach? I think the app-schema module (since a long long time ago) should be split into two, because it's taking care of two orthogonal concerns: - app schema mapping - O/R mapping One thing that would be very worth to try,imho, is to have a Hibernate Spatial datastore so we don't have to reinvent the wheel wrt OR mapping, and then thea app schema mapping can use one of those for the final tweaks to make it app-schema conformant.
One nice thing of feature chaining though -as you already mentioned- is that it lets you join heterogeneous data sources (for example, a shapefile and a database table), so it's still a powerful tool. Other than this kind of off topic comment, I'm not sure I can give you a better answer to your actual questions, but the app-schema team will surely do. Cheers, Gabriel > For example, joining could be performed by first getting just the list > of fids of the > top features, and then issuing a query to the sub-feature type using those ids > (and ordering the result by that same field) turning the N+1 problem into a > 1(ids)+1(topmost data)+1(subfeatures) problem instead. > In case there is filtering on the subfeatures the thing could be > reversed, get the > list of top level feature ids from the sub-features applying the filter and > then > start back from the previous approach adding the ids in the main data filter. > Of course database level joining would be preferrable, but it would not spare > us from having generic (and possibly decently performing) strategies to handle > the heterogeneous source data case. > > Cheers > Andrea > > > ----------------------------------------------------- > Ing. Andrea Aime > Senior Software Engineer > > GeoSolutions S.A.S. > Via Poggio alle Viti 1187 > 55054 Massarosa (LU) > Italy > > phone: +39 0584962313 > fax: +39 0584962313 > > http://www.geo-solutions.it > http://geo-solutions.blogspot.com/ > http://www.linkedin.com/in/andreaaime > http://twitter.com/geowolf > > ----------------------------------------------------- > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users -- Gabriel Roldan grol...@opengeo.org Expert service straight from the developers ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users