Dataview - very slow with specific code

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…

1 Like

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
```

So much faster. Thanks a lot!!!

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.