Hey, Since this discussion is about performance and changes to the SMW storage layer, I'd like to bring up an issue I've been having as Semantic Maps dev.
To efficiently do spatial operations on geographical data stored by SMW, support for spatial extensions in MySQL and PostGis in PostGres is needed. Currently there is no way to make use of these database extensions, as the SMW storage layer does not allow for: * specifying what type of index to place on a field (it only allows specifying a field should be indexed) * putting SQL functions in insert and select statements (which is needed to insert or select geographical entities) I'm not sure to what extend supporting this is possible, but it would make a huge difference for working with geographical data in SMW. So I'd be nice if this was kept into consideration when modifications to the storage layer are made. In any case, the current distance query in Semantic Maps already performs way better then the one in older versions of SMW (which was really really ... really bad). More incentive for Wikia to update :) Cheers -- Jeroen De Dauw http://www.bn2vs.com Don't panic. Don't be evil. --
------------------------------------------------------------------------------ Free Software Download: Index, Search & Analyze Logs and other IT data in Real-Time with Splunk. Collect, index and harness all the fast moving IT data generated by your applications, servers and devices whether physical, virtual or in the cloud. Deliver compliance at lower cost and gain new business insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
