nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Speeding up a Query Builder Workflow

MikeD_Anderson

I have a customer that is trying to query their DB using Query Builder. The problem is that the workflow appears to hang after they click "next" on the select database connection dialog (below). I've encountered this before and has to do (I think) with working with a large table. My question is - are there some best practices for dealing with large tables in Query Builder? Are there some preference settings that would help speed up getting to the actual Query Builder part?

Thanks

Accepted answers

martindemel

Hi Mike

In the preference settings there is an option to specify max number of rows which will be checked for defining the format. This is set to 1mio by default. Decreasing this number to eg 1000 should speed up the workflow significantly I believe.

All comments

martindemel

flo_kussener

Hi,

I have a customer who has the same issue: too long to access to the data through the query builder (I will suggest your preference setting), and once it appends, it seems that the dataset is incomplete. Any additionnal idea???

Thank a lot,

Florence

martindemel

Hi Florence, in what sense incomplete?
-. Just missing values
- missing values in dates
- stops reading after a number of rows
- something inbetween the data is not catched
- columns missing
- ...

you can imagine there can be multiple causes for this. And it is crucial to understand what the unwanted behaviour is.

flo_kussener

Hi Martin,
Thank you for your message.
It seems that rows are missing. As if JMP stopped to acquire the data. is there a maximum sample size? I didn't see any option about that.

Note: the data is not really big (80Mo) and the laptop has 8Go

thank a lot for your suggestions,
Florence