<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/posts/speeding-up-tidysummarizedexperiment-through-query-optimisation-and-the-plyxp-backend-dwlt8qdgr" -->

---
title: Speeding up tidySummarizedExperiment through query...
description: tidySummarizedExperiment v1.19.7 introduces significant performance optimizations that eliminate costly tibble round-trips for common operations. The new...
canonical: https://daily.dev/posts/speeding-up-tidysummarizedexperiment-through-query-optimisation-and-the-plyxp-backend-dwlt8qdgr
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:type: website
og:site_name: daily.dev
og:title: Speeding up tidySummarizedExperiment through query optimisation and the plyxp backend | daily.dev
og:description: tidySummarizedExperiment v1.19.7 introduces significant performance optimizations that eliminate costly tibble round-trips for common operations. The new...
og:url: https://daily.dev/posts/speeding-up-tidysummarizedexperiment-through-query-optimisation-and-the-plyxp-backend-dwlt8qdgr
og:image: https://api.daily.dev/og/posts/dWlT8QdGR.png
og:image:alt: Speeding up tidySummarizedExperiment through query optimisation and the plyxp backend
og:image:width: 1200
og:image:height: 630
og:locale: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Speeding up tidySummarizedExperiment through query optimisation and the plyxp backend

**[R-bloggers](https://daily.dev/sources/rbloggers)** · 12 min read · 0 upvotes · 0 comments

## Summary

tidySummarizedExperiment v1.19.7 introduces significant performance optimizations that eliminate costly tibble round-trips for common operations. The new approach decomposes multi-expression mutate calls, analyzes query scope (colData, rowData, assay, or mixed), and routes operations to specialized handlers or the plyxp backend. Benchmarks show up to 26x speedup for mutate operations (median 23.66x), while filter and select see modest gains around 1.1-1.2x. The fallback tibble round-trip path is preserved for complex edge cases.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.r-bloggers.com/2026/03/speeding-up-tidysummarizedexperiment-through-query-optimisation-and-the-plyxp-backend/>

## Similar posts on daily.dev

- [DuckDB \+ dbplyr: When Your Pipeline Gives Different Results Every Time It Runs](https://daily.dev/posts/duckdb-dbplyr-when-your-pipeline-gives-different-results-every-time-it-runs-jg8fbkpqi) · R-bloggers · 0 upvotes · 0 comments

---

Tags: [#r](https://daily.dev/tags/r)

[View this post on daily.dev](https://daily.dev/posts/speeding-up-tidysummarizedexperiment-through-query-optimisation-and-the-plyxp-backend-dwlt8qdgr)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@type":"TechArticle","headline":"Speeding up tidySummarizedExperiment through query optimisation and the plyxp backend","url":"https://daily.dev/posts/speeding-up-tidysummarizedexperiment-through-query-optimisation-and-the-plyxp-backend-dwlt8qdgr","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/speeding-up-tidysummarizedexperiment-through-query-optimisation-and-the-plyxp-backend-dwlt8qdgr"},"datePublished":"2026-03-22T14:26:05.460Z","dateModified":"2026-03-22T14:26:28.364Z","description":"tidySummarizedExperiment v1.19.7 introduces significant performance optimizations that eliminate costly tibble round-trips for common operations. The new...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/d4d4b49ba8b083b9e26a717e6f7a32c8?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/d4d4b49ba8b083b9e26a717e6f7a32c8?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"R-bloggers","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"R-bloggers","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/98bcbbdf72774292a55ceda8f2277f1e","url":"https://daily.dev/sources/rbloggers"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/speeding-up-tidysummarizedexperiment-through-query-optimisation-and-the-plyxp-backend-dwlt8qdgr","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"r","timeRequired":"PT12M"}
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"R-bloggers","item":"https://daily.dev/sources/rbloggers"},{"@type":"ListItem","position":3,"name":"Speeding up tidySummarizedExperiment through query optimisation and the plyxp backend"}]}
```

