Are there any decent reporting tools that can include simple spatial data that don't do dumb things like Spotfire X with a round-trip for every row?
The GIS department asked me if there were any problems with their database because a report with a single small line graphic (converted from a 3002 object to 2002 to WKB) for each row of the report (small table) was taking about 10 minutes to run. That's nuts because doing that and transferring all the data to my puny 3-in-1, 12152 records only took 24 seconds. But that's without the row-by-row round-trip time from/to Azure and whatever slow process Spotfire X uses to render graphics.
I volunteered to look for a faster solution for them. I have a few ideas of my own, but was curious what others might use.