Files Take a Long Time to Open

From Q
Jump to navigation Jump to search

If a project seems to take a seemingly unreasonably long-time to compute it is likely that the cause of this is one or more of:

  • The data files are saved on a network and the network is slow. You can remedy this by saving your file on your computer.
  • The first table in the project is very slow to compute (see Tables Take a Long Time to Compute).
  • It is a large file, but it is not saved as an SPSS file. Q can load large SPSS files much faster than it can load other formats. If your data is large and it is in a different format then consider resaving it as an SPSS file (Tools | Save Data as SPSS File...).
  • It is a large uncompressed SPSS file (1 GB or more). These are very slow to load, and slow to save as QPacks for use in dashboards. You can import the data into Q, omitting all automatic import options, then resave it as a compressed SPSS file (Tools | Save Data as SPSS File...) and update your project with the compressed file. You should notice a dramatic reduction in the size of the data file.
  • It is a large file, is saved as an SPSS file, but is still slow. See Working with Large Data Files.
  • Omit old data (e.g. if you are only showing the last 12 months of data, then delete earlier data).
  • Omit unused variables.