We are experiencing a relative slow ODBC throughput from TD to Microstrategy and I am wondering if this is "as good as it gets" or if the throughput is below standard.
The challenge is that TD is performing nice, but the transfer time of the output of the query is taking a significant time of the total run time of the report. We have tested with the following setup:
Currently this is our environment:
Should I check more things? Am I overlooking something? Or is this really the normal performance of odbc...