Hi, I'm dealing with an application schema that has a number of subelements in the form:
<container-attribute> <someAttribute>...</someAttribute> <repeated>one</repeated> <repeated>two</repeated> <repeated>three</repeated> ... </container-attribute> Imagine a situation where the main type has something like 10 of those sub-attributes. If I go and use feature chaining that will result in 10 sub-queries for each returned main query. That is probably not acceptable performance wise (as in, unusable in practical terms when one has tens of millions of records and the typical query extracts some hundreds or records, resulting in app-schema making some thousands of queries per GetFeature request). I was wondering if those lists of keywords can be stored in a single attribute instead, and unpacked in memory using a CQL expression that turns a comma separate list into a list of values (something like a split function to parse them, but also able to deal with escape chars). Is that going to work at all? Also, I noticed that the guide suggest the usage of some functions such as vocabolaries and the like. Is the store smart enough to invert well known functions and turn them into a native filter? Was wondering if it's also possible to teach the store to treat a xpath like /container/attribute/repeated=two and turn it into a sql looking like "attribute_repeated like '%,two,%', if you get the idea 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-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
