Hi everyone! I have a question about Cloudflare D1 replication and latency: My D1 database’s primar

Hi everyone! I have a question about Cloudflare D1 replication and latency:

My D1 database’s primary region is APAC (I’m in India).

If I call my Worker API without read replicas, my responses in India are around 300ms.

If I enable read replicas, my response time in India goes up to 500–700ms.

For a user in the UK, with read replicas enabled, the response comes from the WEUR region and is under 100ms (which is great!).

But if I turn off read replicas, UK users get responses from APAC and latency is over 700ms.

My question:
Is there any way to make my responses in India faster with D1 replication enabled?
Why is enabling read replicas increasing my latency locally, and what’s the best way to optimize for both my region (India) and global users?

Any tips or best practices would be greatly appreciated!

SSaM Hi everyone! I have a question about Cloudflare D1 replication and latency: My ...

lambrospetrou•6/12/25, 8:30 AM

Without database/account ID details I cannot know for sure, but I can see what you describe happening if the replica you are hitting from India is farther from your main database depending on which region you get routed since India doesn't have a region yet.
There is a plan for optimizing the choice of the replica to be the closest but now it's just selecting the replica of your closest region.

Llambrospetrou Without database/account ID details I cannot know for sure, but I can see what y...

SaMOP•6/12/25, 8:32 AM

45688789-5491-40fc-9532-191a5d7056db -> Database ID

SSaM 45688789-5491-40fc-9532-191a5d7056db -> Database ID

lambrospetrou•6/12/25, 8:47 AM

Do you send traffic in this database? I only see a handful of requests over the past few days.
Either way, my theory seems to be right. Your main database is in Singapore, and the replica of the same region ended up in Japan. :facesad:
Replica placement is the core priority for improving before going GA, so please continue reporting these cases and we examine them.

Llambrospetrou Do you send traffic in this database? I only see a handful of requests over the ...

SaMOP•6/12/25, 8:55 AM

099d4b89-ddcf-4172-830b-565143b85d36 is the database ID for the DB I’ve tested with both UK and India. The database ID I shared earlier is also one of my test databases.

Llambrospetrou Do you send traffic in this database? I only see a handful of requests over the ...

SaMOP•6/12/25, 9:02 AM

Is there anything specific I should do next?

SSaM Is there anything specific I should do next?

lambrospetrou•6/12/25, 9:09 AM

I will check with the team if there is any internal way to move replicas, although I am not aware of any at the moment. Will let you know later today.

Llambrospetrou I will check with the team if there is any internal way to move replicas, althou...

SaMOP•6/12/25, 9:13 AM

Thank you for looking into this. I’ll wait for your update. Let me know if you need anything else from my side.

SSaM Thank you for looking into this. I’ll wait for your update. Let me know if you n...

lambrospetrou•6/12/25, 12:29 PM

Unfortunately, there isn't a tool (it's in the roadmap) to manually relocate replicas. The routing optimization to pick the closest is in progress though, so hopefully it will go out soon.

Llambrospetrou Unfortunately, there isn't a tool (it's in the roadmap) to manually relocate rep...

Gladius•6/12/25, 12:58 PM

It would be great if you guys add a replica in India as well. India has many users but not always have fast internet. Reducing server side latency would increase user experience.

Successful-Arm-3762•6/12/25, 1:30 PM

Hi cloudflare devs, I have a D1 database that I'm using for my production use-case. It is a very small db, but from day 1, I've been facing random >10s wall time on my workers on random db operations. I've optimized queries. This was okay until I was the primary user, but I'm now looking to having more tenants and convert to a 1 db/tenant architecture, so therefore reaching out for help, as I would like to keep using D1.

harmw•6/12/25, 5:54 PM

anyone else running into D1 errors on the CF side?

harmw•6/12/25, 5:55 PM

(error) 17:52:13 [ERROR] Error: D1_ERROR: Internal error while starting up D1 DB storage caused object to be reset.

DaniFoldi•6/12/25, 6:03 PM

could someone nudge ce2951f0-9233-455a-942d-bf1ff6b93538ce2951f0-9233-455a-942d-bf1ff6b93538 database on d0238d3a1eebca7fc036cb766a5e538fd0238d3a1eebca7fc036cb766a5e538f account please, it's giving

Error: D1_ERROR: Internal error while starting up D1 DB storage caused object to be reset.

Error: D1_ERROR: Internal error while starting up D1 DB storage caused object to be reset.

on 100% of requests

parisholley•6/12/25, 6:06 PM

same

parisholley•6/12/25, 6:08 PM

always something with d1

harmw•6/12/25, 6:09 PM

yeah, and hackernews mentions both FireBase and Twitch seeing issues as well

parisholley•6/12/25, 6:15 PM

https://downdetector.com/ - internet is broken

parisholley•6/12/25, 6:15 PM

https://tenor.com/view/friends-joey-door-slam-bye-im-out-gif-3389550

Tenor

Door slam

harmw•6/12/25, 6:18 PM

network issue, as usual

Tory•6/12/25, 6:31 PM

Same D1 errors here. Looks like an outage.

Chaika•6/12/25, 6:31 PM

yup https://www.cloudflarestatus.com/incidents/25r9t0vz99rp

Broad Cloudflare service outages

Sam•6/12/25, 6:45 PM

parisholley•6/12/25, 8:19 PM

funny enough, my d1's with replica work, non-replicated doesn't :p

beingmudit [WePlayDOS]•6/13/25, 7:19 AM

Hey Team, I read an announcement that a new UX layer has been added as D1 explorer but I don't see it in my dashboard. Is it still rolling out? How can I onboard.

Silvan•6/13/25, 8:25 AM

the three dots on the right and then explore data

ctrl-z•6/13/25, 9:09 AM

Hi team, I currently get this error

D1_ERROR: To execute a transaction, please use the state.storage.transaction() or state.storage.transactionSync() APIs ...

D1_ERROR: To execute a transaction, please use the state.storage.transaction() or state.storage.transactionSync() APIs ...

and after some research, I am a bit confused about the current state of D1 vs durable objects.

In order to use transactions via state.storage.transaction(), do I need to stop using D1 and switch over to DO? Or does state.storage.transaction() somehow work for existing D1 databases as well?

ctrl-z•6/13/25, 9:13 AM

also, a related question, as of today, is D1 actually implemented via DO? Is it just the sqlite interface to DO?

Cctrl-z Hi team, I currently get this error `D1_ERROR: To execute a transaction, please ...

lambrospetrou•6/13/25, 9:13 AM

That's probably an underlying error from Durable Objects that we shouldn't surface to users since you don't manage the underlying DOs and cannot run that anyway through D1.

What SQL did you try to run that gave you that error? I don't think I saw it before surfacing to users.

To summarize about transactions, since D1 is remote from your worker the traditional transaction approach of opening a transaction and interleaving JS code with SQL doesn't work (at least with the current implementation). The D1 batch query runs all the given queries within a transaction if you want multiple statements to be executed atomically.

Cctrl-z also, a related question, as of today, is D1 actually implemented via DO? Is it ...

lambrospetrou•6/13/25, 9:14 AM

Yes, you can read a lot of the technical details in https://blog.cloudflare.com/d1-read-replication-beta/

Llambrospetrou That's probably an underlying error from Durable Objects that we shouldn't surfa...

ctrl-z•6/13/25, 9:19 AM

I'm not running sql directly. I'm currently implementing an adapter for an ORM project called remult, and their test suite failed with that error https://github.com/nerdfolio/remult/blob/main/projects/tests/dbs/shared-tests/db-tests.ts#L951-L970
--
So sounds like the short answer still is D1 does not currently js-based transactions and sql-based transactions are done via batching.

ctrl-z•6/13/25, 9:20 AM

If all I need is access to an sqlite database for my app that does support transaction, do durable objects provide that capability at this time?

Cctrl-z If all I need is access to an sqlite database for my app that does support trans...

lambrospetrou•6/13/25, 9:23 AM

Yes, you can use SQLite DOs directly

SSilvan the three dots on the right and then explore data

workerBee•6/13/25, 11:44 AM

Thanks - I was waiting for that too... I wish the default table sort was ID DESC, but otherwise, this is a great update!

Larry•6/13/25, 12:24 PM

Brayden must be a proud papa today

Brayden•6/13/25, 2:33 PM

I couldn't be prouder

Brayden•6/13/25, 2:33 PM

Also we have a new "Explore Data" button coming when you click into a D1 instance, the prod deploy for that I think was moved to Monday so apologies for teasing that one a bit early the other day

beingmudit [WePlayDOS]•6/13/25, 3:17 PM

Ahh i see. No worries, thanks for updating Brayden++++
I guess engineers are handling with a massive incident ATM.

SSuccessful-Arm-3762 Hi cloudflare devs, I have a D1 database that I'm using for my production use-ca...

Successful-Arm-3762•6/13/25, 4:38 PM

bumping this again. Hopefully someone is able to help me.

SSuccessful-Arm-3762 bumping this again. Hopefully someone is able to help me.

lambrospetrou•6/13/25, 5:15 PM

This was okay until I was the primary user, but I'm now looking to having more tenants and convert to a 1 db/tenant architecture, so therefore reaching out for help, as I would like to keep using D1.

I am not sure what's the question here, though.

Regarding the slow latencies, it can be anything. Next time they happen send us the database and account IDs so that we can investigate. When the underlying datacenter has network issues certain operations take longer, so that's just one possible cause. The network can also impact just the response on its way back, not necessarily the query processing. Especially if you return MBs So, without exact timeranges we can't say what is the cause.

Tux•6/13/25, 6:22 PM

Hello guys, I have a question about the pricing of D1 of the paid plan. When it says "First 25 billion / month included" in the Rows read, does that mean I only get 25 billion for the first month and then get charged for the usage or does that reset and I get that every month

TTux Hello guys, I have a question about the pricing of D1 of the paid plan. When it ...

Chaika•6/13/25, 6:25 PM

It means every month the first 25 billion rows read are included with Workers Paid, and you only pay for any over

CChaika It means every month the first 25 billion rows read are included with Workers Pa...

Tux•6/13/25, 6:25 PM

Ah alright perfect. Thanks a lot

SSilvan the three dots on the right and then explore data

gruntlord6•6/13/25, 11:04 PM

I wish it was the default, it's so much nicer then the old UI

CC Tried to use Wrangler 4.19.2, the issue still exists. Unable to export remote Da...

C•6/14/25, 12:11 AM

My database down for 10 hours.
https://github.com/cloudflare/workers-sdk/issues/9578
I can not export, need my data back.

Account ID
32c307ab568d8c7e7f64f6694bce4ee4

Database ID
c932e1d8-5c3f-4c4b-b8d4-cd9352b58a85

GitHub

Export D1 DataBase Error: cell.replace is not a function · Issue #...

What versions & operating system are you using? Windows 11, Node.js & NPM, wrangler 4.16.1 / 4.19.2 / 4.20.0 (All tested) Please provide a link to a minimal reproduction No response Describ...

782-627•6/14/25, 12:13 AM

CC My database down for 10 hours. https://github.com/cloudflare/workers-sdk/issues/...

lambrospetrou•6/14/25, 8:03 AM

I just rebooted your database so the export is killed. The error you are getting means there is a mismatch between the actual data you store and the schema defined in the table. So, the current D1 export logic that creates the SQL statements fails. It's one of the weirdness of the current export implementation and is planned to be reworked.

Llambrospetrou I just rebooted your database so the export is killed. The error you are getting...

lambrospetrou•6/14/25, 8:05 AM

Unfortunately, that error is not transient, it's based on the stored data, so if you try to export again, the same thing will most likely happen. I will raise it with the team to see if someone can work on it soon.

Llambrospetrou Unfortunately, that error is not transient, it's based on the stored data, so if...

C•6/14/25, 10:20 AM

Thank you so much! I will not export again until it get fixed.

CC Thank you so much! I will not export again until it get fixed.

gruntlord6•6/15/25, 5:13 PM

you could just have the worker export the data manually if they aren't able to get it doing and you need it sooner

gruntlord6•6/15/25, 5:13 PM

or copy to another database with the correct schema and export from there

Hi everyone! I have a question about Cloudflare D1 replication and latency: My D1 database’s primar

Similar Threads

Similar Threads

Similar Threads