CSV Data Export Timing Out on Large Tables
When users try to export data as CSV from your Base44 app, the export hangs, times out, or produces an incomplete file with only some of the records. Small tables export fine, but any table with more than a few thousand rows fails consistently.
Data export is essential for reporting, backups, accounting, and compliance. When users can't get their data out of the app, they lose trust in the platform and may need to manually copy records, which is error-prone and time-consuming.
The timeout typically happens because the export tries to load all records into memory at once, serialize them, and send them in a single HTTP response. For large tables, this exceeds memory limits or connection timeouts.
Error Messages You Might See
Common Causes
- Loading all records into memory — The export function fetches all rows at once instead of streaming or paginating
- HTTP timeout exceeded — The server or proxy has a 30-60 second timeout and large exports take longer
- No streaming response — The entire CSV is built in memory before sending, instead of streaming rows as they're processed
- Related data lookups per row — Each row triggers additional database queries for related fields, causing N+1 performance
- Large text fields — Records contain very long text fields or base64-encoded files that bloat the CSV size
How to Fix It
- Implement paginated export — Fetch and write records in batches of 500-1000, streaming the CSV output instead of building it all in memory
- Use background export — For tables over 5000 rows, generate the CSV in a background job and email the download link to the user
- Exclude large fields — Give users the option to select which columns to export, excluding large text or binary fields
- Increase timeout for exports — Set a longer timeout (5 minutes) specifically for export endpoints
- Add progress indication — Show users a progress bar or status updates during long exports so they know it's working
Real developers can help you.
You don't need to be technical. Just describe what's wrong and a verified developer will handle the rest.
Get HelpFrequently Asked Questions
Why does my CSV export fail for large tables?
Most export functions try to load all records into memory at once. For tables with thousands of rows, this exceeds memory limits or connection timeouts. The fix is to stream records in batches or use background processing.
Can I export only specific columns from my Base44 table?
If the built-in export doesn't support column selection, create a filtered view with only the columns you need, then export from that view. This also reduces the export file size and processing time.