Dataview - very slow with specific code

Help
1

What I’m trying to do

I’m trying this code:


TABLE created, updated as modified, tags, summary
FROM "" AND !"Calendar/Journal" AND !"Atlas/Utilities/Templates"
WHERE dateformat(file.ctime, "YYYY-MM-DD") = dateformat(this.file.ctime, "YYYY-MM-DD")

When i open a note with this code, the note opens veeeeery slow. I have over 9k notes. Not sure if obsidian and dataview + specific code does slow down my obsidian`?

Things I have tried

I’ deleted the code from the Note, afert that its so much faster…

2

Hello.

Don’t know the answer to your question, but any faster if file.cday is used instead (as time, I assume, isn’t being processed)?

```dataview
TABLE created, updated as modified, tags, summary
FROM "" AND !"Calendar/Journal" AND !"Atlas/Utilities/Templates"
WHERE file.cday = this.file.cday
```
3

So much faster. Thanks a lot!!!