While we hope you never run into this situation, there are some steps you can take to help alleviate some of the biggest problems.
If a table is slow to calculate or seems to take an unreasonably long-time to compute, it is likely that the cause of this is one or more of:
- The table is using a large amount of data. For example, a Pick Any - Grid question with 20 rows and 20 columns will be computed using 361 variables, and will thus take time to both extract the data and compute the variables.
- You are using banners when there is no need to use them. For example:
- If there is only one question in your banner, it will generally be much faster to select that question in the Brown Drop-down Menu rather than use a Banner. The reason for this is that in the underlying computations, Q treats each category of the banner as a single variable. Thus if you have a question with, say, 100 categories, it creates 100 variables, which can substantially slow down performance.
- If a banner includes a variable that is only being used as a filter, it will generally be substantially faster to remove it from the banner, and instead, use it to Filter the table.
- An Experiment or Ranking question is being analyzed.
- The table is very large. For example, where an ID variable is set as a Pick One question then any table that uses this question will be very large (e.g., if you have 10,000 respondents in the data file the table will contain 10,000 rows or columns).