---
description: Beginning November 4, 2026, D1 queries that return a result larger than 50 MB will fail and return an error.
title: D1 will enforce a maximum query result size of 50 MB
image: https://developers.cloudflare.com/changelog/post/2026-10-30-query-result-size-limit/og.png?v=5959ffcb384e87b5
---

[Skip to content](#main-content)

[View RSS feeds](https://developers.cloudflare.com/fundamentals/new-features/available-rss-feeds/) [ Subscribe to RSS](https://developers.cloudflare.com/changelog/rss/index.xml)

[Back to all posts](https://developers.cloudflare.com/changelog)

October 30, 2026

## D1 will enforce a maximum query result size of 50 MB

[D1](https://developers.cloudflare.com/d1/)

Copy as Markdown| [View as Markdown](https://developers.cloudflare.com/changelog/post/2026-10-30-query-result-size-limit/index.md)| [Agent setup](https://developers.cloudflare.com/agent-setup/)

Beginning Wednesday, November 4, 2026, D1 will enforce a maximum query result size of 50 MB. Queries that return a result larger than 50 MB will fail and return the following error:

```txt
D1 query result exceeded the maximum response size limit of 50 MB
```

The 50 MB limit covers the 99.999th percentile of requests across D1, so most D1 users will not be impacted.

[Import and export](https://developers.cloudflare.com/d1/best-practices/import-export-data/) operations via the [REST API](https://developers.cloudflare.com/api/resources/d1/subresources/database/methods/export/) are not subject to this limit and will continue to work as they do today.

If your queries return large results, reduce the result size before the enforcement date. For example, select only the columns you need instead of using `SELECT *`, and paginate large result sets with `LIMIT` and `OFFSET`.

For more information, refer to [D1 limits](https://developers.cloudflare.com/d1/platform/limits/) and the [D1 error list](https://developers.cloudflare.com/d1/observability/debug-d1/#error-list).

```json
{"@context":"https://schema.org","@type":"BlogPosting","@id":"https://developers.cloudflare.com/changelog/post/2026-10-30-query-result-size-limit/#page","headline":"D1 will enforce a maximum query result size of 50 MB","description":"Beginning November 4, 2026, D1 queries that return a result larger than 50 MB will fail and return an error.","url":"https://developers.cloudflare.com/changelog/post/2026-10-30-query-result-size-limit/","inLanguage":"en","image":"https://developers.cloudflare.com/changelog/post/2026-10-30-query-result-size-limit/og.png?v=5959ffcb384e87b5","dateModified":"2026-10-30","datePublished":"2026-10-30","publisher":{"@type":"Organization","name":"Cloudflare","description":"One platform for your apps, agents, and workforce. Build, secure, and scale without managing infrastructure","url":"https://www.cloudflare.com/","sameAs":["https://github.com/cloudflare","https://www.linkedin.com/company/cloudflare","https://x.com/cloudflare"],"logo":{"@type":"ImageObject","url":"https://developers.cloudflare.com/logo.svg"},"address":{"@type":"PostalAddress","streetAddress":"101 Townsend St","addressLocality":"San Francisco","addressRegion":"CA","postalCode":"94107","addressCountry":"US"},"contactPoint":[{"@type":"ContactPoint","contactType":"Customer Support","url":"https://support.cloudflare.com/","availableLanguage":["English"]},{"@type":"ContactPoint","contactType":"Sales","url":"https://www.cloudflare.com/contact/","availableLanguage":["English"]}]},"isPartOf":{"@type":"WebSite","@id":"https://developers.cloudflare.com/#website","name":"Cloudflare Docs","url":"https://developers.cloudflare.com/"}}
```