I have a large database on sql Server 2012 Developers edition, some tables are 
upto 10GB in size,  I have been connecting fine to the database and extracting 
info.  
today was the first time I tried to pull 1/2 gb in one query, nothing fancy a 
query that always worked with smaller size.

R dropped the work without providing an error message.  I got the "sand clock" 
running for a couple of seconds, as if R had stared communication with the 
database, but 
then nothing. I looked at my windows task manger, and CPU utilization was at 
zero.

I ran memory.size() function to confirm availability of memory and it read 24 
thousand I don't remember the rest, I have 24GBs of ram on my computer.  the 
size of the other R objects in memory was around 2GB

Are there any known issues between RODBC and SQLServer?



thanks

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-db

Reply via email to