Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.6k views
in Technique[技术] by (71.8m points)

shiny - How do i perform paging through BigQuery in R?

I am fetching a large data table (around 50k rows) via bigrquery and after performing some calculation displaying that data table in shiny dashboard. The problem is bigquery is taking around 10 seconds to load the data and I want to reduce this time.

One thing I came across is Paging through data table. But I am facing trouble implementing this in R.

I also tried using max_results and start_index as combination:

df = bq_project_query(project_id,str_interp(query),use_legacy_sql = TRUE,
                        max_pages = Inf,destination_table = NULL,default_dataset = NULL) %>%
    bq_table_download(max_results = 5000,start_index = si) %>% as_tibble()

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神解答

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share
...