I think the timeout for RCurl defaults to 200 seconds which may not be long enough for some requests. I don't think we need to make it as extreme as the server timeout of 30min. We can call it with a specific timeout so maybe changing the default to 10-15 minutes would help support longer queries or we could use some function based on the length of the list to set the timeout. The time required for most requests is related to the length of the list of targets and miRNAs. It can handle a longer list of targets than it can handle a longer list of miRNAs.
However I did try to create appropriate indices for most queries in each table so it should speed queries up.
I think the timeout for RCurl defaults to 200 seconds which may not be long enough for some requests. I don't think we need to make it as extreme as the server timeout of 30min. We can call it with a specific timeout so maybe changing the default to 10-15 minutes would help support longer queries or we could use some function based on the length of the list to set the timeout. The time required for most requests is related to the length of the list of targets and miRNAs. It can handle a longer list of targets than it can handle a longer list of miRNAs.
However I did try to create appropriate indices for most queries in each table so it should speed queries up.