It depends entirely on the index and the query!

Hey!
Is there an estimate of what should be the expected per-db storage limit after the beta is over?

2GB would be way too low for any production application, and i understand it will probably be increased, but i'd like to know how high is it expected to go, as i know that the intended use case is "one db per user" but we expected to use it as a normal database.

Natan Parmigiano•2/2/24, 8:09 PM

is there any way of "dynamically binding" a D1 database?
I cant see a way of applying the idea of using D1 in a multitenant environment without needing to manage a worker deployment for every customer..

NNatan Parmigiano Hey! Is there an estimate of what should be the expected per-db storage limit af...

Cyb3r-Jak3•2/2/24, 8:15 PM

See d1-database.

Discord

Discord - A New Way to Chat with Friends & Communities

Discord is the easiest way to communicate over voice, video, and text. Chat, hang out, and stay close with your friends and communities.

NNatan Parmigiano is there any way of "dynamically binding" a D1 database? I cant see a way of app...

Cyb3r-Jak3•2/2/24, 8:15 PM

Not yet but it something planned

CCyb3r-Jak3 See https://discord.com/channels/595317990191398933/992060581832032316/115723945...

Natan Parmigiano•2/2/24, 8:17 PM

That answers my question!

MMatt Silverlock Double digits makes sense. 100GB _per database_ is just a very different thing. ...

Vignesh•2/3/24, 7:32 AM

For this to happen will Cloudflare does horizontal scaling automatically in the background or are we supposed to do it manually?

MMatt Silverlock It depends entirely on the index and the query!

Ɽ

ⱤØ₥₳₦•2/3/24, 7:51 AM

Like if there is a table with millions of rows and that has timestamp column and i use that for index, then?

ⱤⱤØ₥₳₦Like if there is a table with millions of rows and that has timestamp column and...

Matt SilverlockOP•2/3/24, 8:47 AM

Then the rows scanned will depend on how the query uses the timestamp and the index. I strongly suggest reading https://developers.cloudflare.com/d1/how-to/using-indexes/

Cloudflare Docs

Use indexes · Cloudflare D1 docs

Indexes enable D1 to improve query performance over the indexed columns for common (popular) queries by reducing the amount of data (number of rows) …