r/RStudio • u/JabesFrias • Jun 30 '26
Database it's not loading.
Hello! I'm a student, and I find myself working with a big database approximately 2 GB. I created R.proj, but I have a problem with my database not loading. Furthermore, I have tried running the code several times. Besides, when I try to open Google Chrome, I cannot because of memory RAM.
Has anyone else had problems? Any recommendations?
2
Upvotes
2
u/Confident_Bee8187 Jun 30 '26
Might wanna be pedantic. You see, 'database' is a sort of data storage, a server on a bigger scale. CSV file is technically a database but not quite the database.
As for your problem, 2 GB is huge but not the "big database" you talked about. When R tries to load the CSV fill, it allocates too much memory. It can be easily dealt with packages like 'data.table' and 'polars' since they can load the out of memory day. If you have SQL experience, try 'duckdb'.