# Dataview - very slow with specific code

**URL:** <https://forum.obsidian.md/t/dataview-very-slow-with-specific-code/90981>\
**Category:** Help\
**Created:** [November 4, 2024, 1:42pm UTC](https://forum.obsidian.md/t/dataview-very-slow-with-specific-code/90981 "2024-11-04T13:42:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![SJSchneider](https://forum.obsidian.md/user_avatar/forum.obsidian.md/sjschneider/32/72600_2.png) [@SJSchneider](https://forum.obsidian.md/u/SJSchneider)\
**Post date:** [November 4, 2024, 1:42pm UTC](https://forum.obsidian.md/t/dataview-very-slow-with-specific-code/90981/1 "2024-11-04T13:42:46Z")

</div>

### What I’m trying to do

I’m trying this code:

```auto

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…

---

<div class="post-metadata">

**Author:** ![anon45210282](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/a/d6d6ee/32.png) [@anon45210282](https://forum.obsidian.md/u/anon45210282)\
**Post date:** [November 4, 2024, 2:00pm UTC](https://forum.obsidian.md/t/dataview-very-slow-with-specific-code/90981/2 "2024-11-04T14:00:46Z")

</div>

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)?

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

````

---

<div class="post-metadata">

**Author:** ![SJSchneider](https://forum.obsidian.md/user_avatar/forum.obsidian.md/sjschneider/32/72600_2.png) [@SJSchneider](https://forum.obsidian.md/u/SJSchneider)\
**Post date:** [November 5, 2024, 5:47am UTC](https://forum.obsidian.md/t/dataview-very-slow-with-specific-code/90981/3 "2024-11-05T05:47:39Z")

</div>

So much faster. Thanks a lot!!!

---

<div class="post-metadata">

**Author:** ![system](https://forum.obsidian.md/uploads/default/original/3X/b/e/bec35fbd23ab28909bb6bfe62cb32eb82dd34019.png) [@system](https://forum.obsidian.md/u/system)\
**Post date:** [December 3, 2024, 5:47am UTC](https://forum.obsidian.md/t/dataview-very-slow-with-specific-code/90981/4 "2024-12-03T05:47:49Z")

</div>

Closed on December 3, 2024, 5:47am UTC

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