Uploading 1.3million rows of data

Need help Database
1

Hi,

I have a CSV file with 1.3 million rows of data (just three columns with 1 word per column). I’ve been trying to upload this a few times (leaving my computer on for 18 hours at one point) but it just doesn’t seem to load. The furthest I’ve gotten to is 150,000 rows after those 18 hours.

The data is quite static and won’t change much.

How can I go about doing this? The data is essential for my app.

Thanks,
Bram

2

Try doing it in batches. I believe @emmanuel suggested this in a post I read awhile ago.

Maybe 50k at a time.

1 Like