locked
Speed of queries via ODBC RRS feed

  • General discussion

  • I use powerpivot to retrieve data from a intersystems cache-db via ODBC, writing my own SQL-Queries (A thing I never wanted to do, but hey, I like it now ;) ).

    Simple queries without joins are executed pretty fast, but once I start joining tables, they are significantly slower, sometimes it takes several minutes before the Powerpivot starts to retrieve rows.

    Is this normal? On what does it depend? The database Version, odbc-driver and server hardware are rather old, but we are planning to update the DB, so I could use a newer 64bit odbc driver. Could that help?

    Any ideas? Thanks in advance

    Carsten

    The tables are joined by indexed fields only.


    Wednesday, March 20, 2013 12:09 PM

All replies