In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Calgary Database - Slow?

Bonediggler
9 - Comet

Experts - 

I built a Calgary database of about 67 million records with a few indices.  I ran a query - Alteryx notified me within seconds that "Calgary found 190K matching records out of 67M", which is great.  However, outputting those 190K records has taken 20 minutes so far and still isn't done.

 

Undoubtedly this is better performance than via .yxdb which would take many hours, however it seems to be way too long given Calgary's promise of  "extremely fast queries."

 

I don't think I messed up the selectivity settings on the indices.  Am I doing something wrong?

 

Thanks in advance!

0 REPLIES 0
Labels
Top Solution Authors