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 Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. 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