RSQLite slowness
https://support.bioconductor.org and the community slack (sign up at https://bioc-community.herokuapp.com/ ) as well as the general site https://bioconductor.org . Actually your question sounds like a SQLite question ? JOIN a table, versus parameterized query. One could perhaps construct the relevant example at the sqlite command line? Martin Morgan
On 10/6/21, 2:50 PM, "R-help" <r-help-bounces at r-project.org> wrote:
Thank you Bert, I set up a new thread on BioStars [1]. So far, I'm a bit unfamilliar with Bioconductor (but will hopefully attend a course about it in November, which I'm kinda hyped about), other than installing and updating R packages using BiocManager .... Did you think of something else than BioStars.org when saying ?Bioconductor?? The question could be viewed as gene related, but I think it is really about how can one easier than with sqlite handle large tsv files, and why is that parser thing so slow ... I think this is more like a core R thing than gene related question ... [1] https://www.biostars.org/p/9492486/