Answers.Body: <p>This depends on your installation and the mechanism you're using for exporting.</p>
  <p><code>Export &lt;contacts/contributions/etc.&gt;</code> will download more records that SearchKit's <code>Download Spreadsheet</code>.  However, the PHP timeout setting in your server's <code>php.ini</code> might need to be increased.  Another possibility is that your <code>/tmp</code> directory isn't large enough for the file you're creating.  That would require either increasing the space, or editing your MySQL/MariaDB configuration to generate temporary tables somewhere else.</p>
  <p>If you're good with SQL, you can also use <code>SQL Tasks</code> to hand-write the SQL that generates the results you want.  It has an option to export the results to CSV and email them to you.  Hand written SQL will run much faster, and I think (but not sure) will avoid the temporary table space issue.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-09-25T10:47:37.970Z
Answers.Text: Thank you. I'll check the timeout possibility. I haven't explored SQL Tasks yet; it's all new to me, but I would guess that I could take the SQL of the SearchKit as a starting point.
Answers.UserDisplayName: Michael FORWARD
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-09-23T17:34:40.577Z
Answers.LastActivityDate: 2024-09-23T17:34:40.577Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>There is an issue registered that addresses this <a href="https://lab.civicrm.org/dev/core/-/issues/4085" rel="nofollow noreferrer">SearchKit can't export more than a couple thousand rows</a>.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-11-07T12:13:33.757Z
Answers.LastActivityDate: 2024-11-07T12:13:33.757Z
Answers.UserDisplayName: Francesc Bassas i Bullich
Body: <p>I am finding that above a certain number of rows, it is not possible to export the results of a search. 15000 seems to be OK, but with 49000 rows, the export function simply does nothing. No error message, just a progress bar that stops.</p>
  <p>Is there a built-in limit, or does it depend on installation?</p>
  
Tags: <searchkit><export>
Title: maximum number of search results that can be exported
ThreadText: # maximum number of search results that can be exported
  
  (Asked by: username_0 on 2024-09-19)
  
  I am finding that above a certain number of rows, it is not possible to export the results of a search. 15000 seems to be OK, but with 49000 rows, the export function simply does nothing. No error message, just a progress bar that stops.
  
  Is there a built-in limit, or does it depend on installation?
  
  **Tags:** searchkit, export
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2024-09-23. Score: 2
  
  This depends on your installation and the mechanism you're using for exporting.
  
  `Export <contacts/contributions/etc.>` will download more records that SearchKit's `Download Spreadsheet`. However, the PHP timeout setting in your server's `php.ini` might need to be increased. Another possibility is that your `/tmp` directory isn't large enough for the file you're creating. That would require either increasing the space, or editing your MySQL/MariaDB configuration to generate temporary tables somewhere else.
  
  If you're good with SQL, you can also use `SQL Tasks` to hand-write the SQL that generates the results you want. It has an option to export the results to CSV and email them to you. Hand written SQL will run much faster, and I think (but not sure) will avoid the temporary table space issue.
  
  > **Comments:**
  > **username_0**: Thank you. I'll check the timeout possibility. I haven't explored SQL Tasks yet; it's all new to me, but I would guess that I could take the SQL of the SearchKit as a starting point.  
  
  ---
  
  ### Answer by username_2 on 2024-11-07. Score: 1
  
  There is an issue registered that addresses this [SearchKit can't export more than a couple thousand rows](https://lab.civicrm.org/dev/core/-/issues/4085).
  
  
  ---
  
  