I forget, do D1 requests count towards the overall Worker subrequest limit? - Cloudflare Developers

© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy

Original message was deleted

dave

D

daveOP•10/5/23, 6:25 PM

Did you find an answer for this?

dave

Ddave I forget, do D1 requests count towards the overall Worker subrequest limit?

Matt Silverlock

M

Matt Silverlock•10/5/23, 6:27 PM

Yes

Matt Silverlock

MMatt Silverlock Yes

dave

D

daveOP•10/5/23, 6:30 PM

thanks! And

.batch()

.batch()

only counts as one subrequest I assume, regardless of the number of statements? https://developers.cloudflare.com/d1/platform/client-api/#dbbatch

Unsmart

U

Unsmart•10/5/23, 6:59 PM

The "new" backend which has been the default and only really supported option for quite some time now limits depths of queries to 20. You basically need to create queries that do not go over that limit.

There was a github issue about it you can see here if you want to add your example and request for this limit to be upped in the future: https://github.com/cloudflare/workers-sdk/issues/4094

Unsmart

U

Unsmart•10/5/23, 7:15 PM

I have no clue I do not use SQL databases and have no knowledge of query depths or anything

SPS | Shootmail

SSPS | Shootmail `Expression tree is too large (maximum depth 20)` I deleted my old dB that was c...

Jason Hostetter

J

Jason Hostetter•10/6/23, 1:46 AM

I hit this same error a while back, and after a lot of digging I could not for the life of me figure out how expression depth was calculated, whether my query had a depth of 21 or 121, or any useful information about how to decrease depth. I ended up splitting the query into two separate queries instead of using a common table expression (an ordinary CTE, not a recursive one even), and the error went away. Cloudflare devs at the time sounded open to increasing the max depth (default sqlite is set at like 1000 or something), but again I couldn't say what number I would need! So all that to say...

Jason Hostetter

J

Jason Hostetter•10/6/23, 1:51 AM

Just saw the comment from @Unsmart | Tech debt and the github issue after writing all that lol. Really wish the sqlite error also reported the query expression depth.

Hữu Phong

H

Hữu Phong•10/6/23, 4:13 AM

Is there anyway to use D1 with TablePlus?

Cretezy

C

Cretezy•10/6/23, 4:53 AM

It should be noted in the documentation for the client API (https://developers.cloudflare.com/d1/platform/client-api) how

success

success

is handled.
It's returned from

run

run

/

batch

batch

, but

first

first

/

all

all

don't have it

D1 client API · Cloudflare D1 docs

As part of our Client API, both static and prepared statements are supported. Best practice is to use prepared statements which are precompiled …

Cretezy

C

Cretezy•10/6/23, 4:54 AM

Also seems like

success: true

success: true

is forced in the typings, so presumably it's not even useful?

Cretezy

C

Cretezy•10/6/23, 6:03 AM

Also, are

batch

batch

ran sequencially? Would it work if I read a row in the 1st batched statement, but delete the same row in the 2nd statement?

Cretezy

CCretezy Also seems like `success: true` is forced in the typings, so presumably it's not...

Max (@rozenmd)

M

Max (@rozenmd)•10/6/23, 8:16 AM

?

  success: boolean, // true if the operation was successful, false otherwise

  success: boolean, // true if the operation was successful, false otherwise

Matt Silverlock

MMatt Silverlock Yes, if you are using `—remote` mode in wrangler

Adi//

A

Adi//•10/6/23, 9:24 AM

is this solved now?

Adi//

AAdi//is this solved now?

Matt Silverlock

M

Matt Silverlock•10/6/23, 9:40 AM

Yes, the incident you were asking about has been closed since yesterday

Matt Silverlock

MMatt Silverlock Yes, the incident you were asking about has been closed since yesterday

Adi//

A

Adi//•10/6/23, 9:44 AM

ok ok, lol i was trying to work on a cron worker at the same time and --remote kept failing

good to know there was no mistake on my end

SPS | Shootmail

SSPS | Shootmail https://github.com/cloudflare/workerd/pull/1279 Is this being merged today to fi...

Matt Silverlock

M

Matt Silverlock•10/6/23, 10:02 AM

To be transparent: no. Also merging is not the same as releasing. Hold tight.

SPS | Shootmail

SSPS | Shootmail Any expected date, so that i can decide my next steps. I cannot move forward wit...

Matt Silverlock

M

Matt Silverlock•10/6/23, 10:15 AM

Our goal is within the next week. I strongly suggest you refactor how you are performing your joins in the meantime if you need to unblock yourself. The current limit isn’t high but we’ve rarely had folks run into it so directly.

Vikash

VVikash The database is for testing, feel free to takeover if you want to test? Or shoul...

Vikash

V

Vikash•10/6/23, 10:20 AM

@rozenmd Any suggestion on 1 second slowness in all queries?

Vikash

VVikash @rozenmd Any suggestion on 1 second slowness in all queries?

Matt Silverlock

M

Matt Silverlock•10/6/23, 11:37 AM

You should not expect D1 to be outright faster than a hot (cached) KV read. How are you measuring query performance? What is the duration of the query itself, as reported in

result.meta.duration

result.meta.duration

and then the time for the D1 API call without your application code?

Matt Silverlock

MMatt Silverlock You should not expect D1 to be outright faster than a hot (cached) KV read. How ...

Vikash

V

Vikash•10/6/23, 11:46 AM

Yes, I am not considering that. Here is response on a worker where duration is : 0.689.
I guess that's more half second.

"success":true,"meta":{"served_by":"v3-prod","duration":0.689,"changes":0,"last_row_id":0,"changed_db":false,"size_after":81920,"rows_read":43,"rows_written":0},"results": [....]

"success":true,"meta":{"served_by":"v3-prod","duration":0.689,"changes":0,"last_row_id":0,"changed_db":false,"size_after":81920,"rows_read":43,"rows_written":0},"results": [....]

https://development.pricetree-angular.pages.dev/api/products

Vikash

V

Vikash•10/6/23, 11:48 AM

And some time even more than 1 second -

Kuririn

K

Kuririn•10/6/23, 12:01 PM

I have query like this:

const response = await env.DB.prepare(`
                UPDATE Promotions 
                SET content = ?, last_update_time = ?
                WHERE promo_id = ?
            `).bind(JSON.stringify(page), currentTimeInSeconds, page.id).run();

const response = await env.DB.prepare(`
                UPDATE Promotions 
                SET content = ?, last_update_time = ?
                WHERE promo_id = ?
            `).bind(JSON.stringify(page), currentTimeInSeconds, page.id).run();

but it doesn't update the record and doesn’t return anything or throw an error.

My only idea is that page is too big, but something similar works for insert.
But it would be weird that I can't update big values (article).

Vikash

VVikash And some time even more than 1 second -

Matt Silverlock

M

Matt Silverlock•10/6/23, 12:19 PM

Duration is in milliseconds

Kuririn

KKuririn I have query like this: ```const response = await env.DB.prepare(` ...

Matt Silverlock

M

Matt Silverlock•10/6/23, 12:19 PM

Try it without calling stringify, and just pass in a plain value first

Matt Silverlock

MMatt Silverlock Try it without calling stringify, and just pass in a plain value first

Vikash

V

Vikash•10/6/23, 12:21 PM

I am using Hono

.json()

.json()

, I will test without that -

products.get('/', async (c) => {
const { offset = 0, limit = 1000 } = c.req.query();
const results = await getProducts(c, Number(offset), Number(limit));
return c.json(results as Product[]);
});

Vikash

VVikash I am using Hono `.json()`, I will test without that - products.get('/', async...

Matt Silverlock

M

Matt Silverlock•10/6/23, 12:25 PM

I replied to the other user

Matt Silverlock

MMatt Silverlock I replied to the other user 🙂

Vikash

V

Vikash•10/6/23, 12:26 PM

Matt Silverlock

MMatt Silverlock Try it without calling stringify, and just pass in a plain value first

Kuririn

K

Kuririn•10/6/23, 12:55 PM

It doesn’t work without stringify, but I noticed it worked once finally (after many trials). It was probably cloudflare issue (didn't execute code and didn't return the promise). I will test it again.

Kuririn

KKuririn It doesn’t work without stringify, but I noticed it worked once finally (after m...

Matt Silverlock

M

Matt Silverlock•10/6/23, 12:57 PM

And you changed nothing at all?

Kuririn

K

Kuririn•10/6/23, 1:01 PM

let me check again, I'm trying so many different things that I'm confused

Kuririn

K

Kuririn•10/6/23, 1:06 PM

Sorry man! It worked without stringify. I got some D1 error about object when testing before but it worked nevertheless. And now it works without the object error.

Kuririn

K

Kuririn•10/6/23, 1:06 PM

I'm using insert with strinigify and it works, when I should use it and when not?

touhidurrr 🇵🇸

Ttouhidurrr 🇵🇸Is there any way to use D1 directly from my app without using workers?

Kuririn

K

Kuririn•10/6/23, 1:09 PM

I don't think so. I use worker to provide an api for my app.

Kuririn

KKuririn Sorry man! It worked without stringify. I got some D1 error about object when te...

Kuririn

K

Kuririn•10/6/23, 1:12 PM

I got the error again:
for value "D1_TYPE_ERROR: Type 'object' not supported [Object object]''

Kuririn

K

Kuririn•10/6/23, 1:13 PM

I'm totally confused now, because it worked once, then without changing the code it throw this error

Kuririn

K

Kuririn•10/6/23, 1:15 PM

orr diffrent versions are running, I will check without stringify once again

Kuririn

KKuririn I'm using insert with strinigify and it works, when I should use it and when not...

Matt Silverlock

M

Matt Silverlock•10/6/23, 1:18 PM

Your JSON.stringify call is likely returning an object that isn’t what your query can bind. You should prep the bound variable before you pass it to your query.

Kuririn

KKuririn I got the error again: for value "D1_TYPE_ERROR: Type 'object' not supported [Ob...

Matt Silverlock

M

Matt Silverlock•10/6/23, 1:18 PM

If you stringify and then log that result I guarantee it is not what you are expecting

Kuririn

K

Kuririn•10/6/23, 1:37 PM

I finally figured it out, this call was in async foreach loop and script ended too soon without waiting for the response , I changed it to for of loop and it seems to work now

EvanPiro

E

EvanPiro•10/6/23, 3:28 PM

Is it possible to easily pull a remote database copy into local using wrangler?

const response = await env.DB.prepare(`
                UPDATE Promotions 
                SET content = ?, last_update_time = ?
                WHERE promo_id = ?
            `).bind(JSON.stringify(page), currentTimeInSeconds, page.id).run();

const response = await env.DB.prepare(`
                UPDATE Promotions 
                SET content = ?, last_update_time = ?
                WHERE promo_id = ?
            `).bind(JSON.stringify(page), currentTimeInSeconds, page.id).run();