You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@allura.apache.org by Dave Brondsema <da...@brondsema.net> on 2022/03/30 16:58:10 UTC

[allura:tickets] #8422 optimize more discussion thread queries



---

** [tickets:#8422] optimize more discussion thread queries**

**Status:** open
**Milestone:** unreleased
**Labels:** performance 
**Created:** Wed Mar 30, 2022 04:58 PM UTC by Dave Brondsema
**Last Updated:** Wed Mar 30, 2022 04:58 PM UTC
**Owner:** nobody


followup to [#4359]  Like it did with backrefs can we consolidate queries for:

- `ForumAttachment` queries
- additional `ArtifactReference` queries, maybe these are regular ("forward") references from `def related_artifacts` calling `self.refs`




---

Sent from forge-allura.apache.org because dev@allura.apache.org is subscribed to https://forge-allura.apache.org/p/allura/tickets/

To unsubscribe from further messages, a project admin can change settings at https://forge-allura.apache.org/p/allura/admin/tickets/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[allura:tickets] #8422 optimize more discussion thread queries

Posted by Dillon Walls <di...@slashdotmedia.com.INVALID>.
dw/8422

I did similar batch fetching in the thread widget for each post in the thread. We now also batch look up ArtifactReferences as well as Attachments. This should work for all type of threads (i.e. discussion, ticket discussion, wiki responses, etc.).


---

** [tickets:#8422] optimize more discussion thread queries**

**Status:** open
**Milestone:** unreleased
**Labels:** performance 
**Created:** Wed Mar 30, 2022 04:58 PM UTC by Dave Brondsema
**Last Updated:** Wed Mar 30, 2022 04:58 PM UTC
**Owner:** nobody


followup to [#4359]  Like it did with backrefs can we consolidate queries for:

- `ForumAttachment` queries
- additional `ArtifactReference` queries, maybe these are regular ("forward") references from `def related_artifacts` calling `self.refs`




---

Sent from forge-allura.apache.org because dev@allura.apache.org is subscribed to https://forge-allura.apache.org/p/allura/tickets/

To unsubscribe from further messages, a project admin can change settings at https://forge-allura.apache.org/p/allura/admin/tickets/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[allura:tickets] #8422 optimize more discussion thread queries

Posted by Dillon Walls <di...@slashdotmedia.com.INVALID>.
- **status**: open --> review



---

** [tickets:#8422] optimize more discussion thread queries**

**Status:** review
**Milestone:** unreleased
**Labels:** performance 
**Created:** Wed Mar 30, 2022 04:58 PM UTC by Dave Brondsema
**Last Updated:** Thu Jun 30, 2022 08:09 PM UTC
**Owner:** nobody


followup to [#4359]  Like it did with backrefs can we consolidate queries for:

- `ForumAttachment` queries
- additional `ArtifactReference` queries, maybe these are regular ("forward") references from `def related_artifacts` calling `self.refs`




---

Sent from forge-allura.apache.org because dev@allura.apache.org is subscribed to https://forge-allura.apache.org/p/allura/tickets/

To unsubscribe from further messages, a project admin can change settings at https://forge-allura.apache.org/p/allura/admin/tickets/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.

[allura:tickets] #8422 optimize more discussion thread queries

Posted by Dave Brondsema <da...@brondsema.net>.
- **status**: review --> closed



---

** [tickets:#8422] optimize more discussion thread queries**

**Status:** closed
**Milestone:** unreleased
**Labels:** performance 
**Created:** Wed Mar 30, 2022 04:58 PM UTC by Dave Brondsema
**Last Updated:** Thu Jun 30, 2022 08:09 PM UTC
**Owner:** nobody


followup to [#4359]  Like it did with backrefs can we consolidate queries for:

- `ForumAttachment` queries
- additional `ArtifactReference` queries, maybe these are regular ("forward") references from `def related_artifacts` calling `self.refs`




---

Sent from forge-allura.apache.org because dev@allura.apache.org is subscribed to https://forge-allura.apache.org/p/allura/tickets/

To unsubscribe from further messages, a project admin can change settings at https://forge-allura.apache.org/p/allura/admin/tickets/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.