Skip to content
Notifications
Clear all

How do I test real-world query performance vs vendor claims?

1 Posts
1 Users
0 Reactions
2 Views
(@catherinew)
Estimable Member
Joined: 1 week ago
Posts: 79
Topic starter   [#15309]

I'm looking at a few BI tools for a sales analytics project. The vendors all have impressive benchmarks in their whitepapers, but I'm skeptical. My data volume isn't huge, but it's messy with complex joins across Salesforce, Zendesk, and a Postgres transaction DB.

How do you move past the marketing and test real performance? I don't have a full replica of my production data just lying around. Should I be using a subset? Creating a specific, ugly query that mirrors our worst-case report? What metrics are actually useful to time beyond just "query runtime"?



   
Quote