cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
View Translated Thread
PS
PS
Level III

JMP Query builder very slow

Mar 28, 2019 12:45 PM (4153 views)

Hi all,

 

I am struggling to use the query builder because it is very slow. Colleagues of mine using a different software, but with otherwise equally configured database connection, can preview a table in a split second. For me it takes 20-60 seconds with frequent freezes of the jmp sofware. Have you experienced the same problems?

 

I understand this is a difficult question without any further knowledge. But maybe somebody has an idea.

(JMP 14.1, 64bit system, the database is gigantic)

 

Thanks and regards

 

1 ACCEPTED SOLUTION

Accepted Solutions
briancorcoran
Staff briancorcoran
Staff
Solution

Re: JMP Query builder very slow

Mar 28, 2019 02:47 PM (4140 views)  |  Posted in reply to message from PS 03-28-2019

If you can't share details here, I would encourage you to write support@jmp.com so that you can share details with Tech Support.  There are a variety of preferences available under Preferences->Query Builder that can be tuned to help with performance, but without knowing the details of your situation (schema, filters, database) etc. it's impossible to make recommendations.

 

Brian Corcoran

JMP Development

 

View solution in original post

1 REPLY 1
briancorcoran
Staff briancorcoran
Staff
Solution

Re: JMP Query builder very slow

Mar 28, 2019 02:47 PM (4141 views)  |  Posted in reply to message from PS 03-28-2019

If you can't share details here, I would encourage you to write support@jmp.com so that you can share details with Tech Support.  There are a variety of preferences available under Preferences->Query Builder that can be tuned to help with performance, but without knowing the details of your situation (schema, filters, database) etc. it's impossible to make recommendations.

 

Brian Corcoran

JMP Development