search

dieterich-lab / nmdtxdb

Shiny application and code for the database for NMD targets
https://shiny.dieterichlab.org/app/NMDtxDB
Other
1 stars 0 forks source link

Improve database responsiveness - use indexes. #4

Closed tbrittoborges closed 1 year ago

tbrittoborges commented 1 year ago

Currently the database queries are not using indexes, as this is not directly supported by dbplyr: Here is workaround https://github.com/tidyverse/dbplyr/issues/484#issuecomment-1143880127

tbrittoborges commented 1 year ago

https://dbplyr.tidyverse.org/reference/tbl.src_dbi.html

tbrittoborges commented 1 year ago

Database indexes were updated independent of any changes in the app.