Questions

I want to download a set of data into excel, about 50,000 records, which can only be downloaded using SQL. What cloud based, or other service could I use? I need bi-monthly updates and need the data converted to Excel.

Lot of missing info in this question.

Like, how data will be accessed (frequency).

This will determine your SQL storage engine type + table structure.

You can also adjust your table structure to protect against duplicate entries.

This is important, if it takes a long time to load your data. If you setup your structure to only allow unique data, then you can just upload your new data, without having to "drop" (destroy) your old data.

This can potentially speed up your data loads considerably, especially if you're using cheap/slow hosting for your database.

Likely good to give equal consideration to how data is used first + data loading.


Answered 7 years ago

Unlock Startups Unlimited

Access 20,000+ Startup Experts, 650+ masterclass videos, 1,000+ in-depth guides, and all the software tools you need to launch and grow quickly.

Already a member? Sign in

Copyright © 2024 Startups.com LLC. All rights reserved.