Is there any way to view the progress of a dbGetQuery() function call? Also, are there any faster alternatives to the function? Have found myself waiting hours for the query to finish running and would like a quicker way to pull the data.
I doubt that any changes in R will speed this up. Your query must just be very hard work for the database server.
Suggestions:
- Reduce number of columns
- Reduce number of rows
- Use TOP (n) to get a subset of rows and see if you can predict how long all rows will take
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.