Forum Discussion
codyraptor
Resolver I
Resolver IDirect Query...Performance Issue
Hey everyone, I have a large dataset and I'm trying to decide between 'import' and 'direct query'. Import takes forever to refresh this model. It sometimes works and sometimes can timeout, so i...
Hi codyraptor
As far as I understand,
In direct query mode you can't see editor window, you see this only in import mode.
The editor view only pull the first n number of rows it doesn't pull the entire data set after evaluating your query. When you hit close and apply now it's trying to pull the entire data set which fails to pull may be due to many number of rows and finally it's getting crashed.