So I think I found a bug where simply
So I think I found a bug where simply looking at a D1 database in the dashboard causes a huge number of rows to be read. I have indexes for all of my queries and the high number of rows read is happening only when I pull up the database (simply looking at the table data).
2 Replies
If this is expected behavior then it should be documented. I spent quite a bit of time trying to figure out whether I had created the indexes properly since these spikes were happening seemingly randomly.
My smallest table has fewer than 500,000 rows.
That seems like a pretty bad side effect for simply hitting a page on the dashboard
I'll remove the row counts tomorrow morning