1

This question is a follow-up to this question I asked on Stack Overflow yesterday after answering my own question by creating a Aurora MySQL db Instance and establishing a connection between it and MySQL Workbench, and like all of the previous variations I have tried, this too failed to noticeably decrease the runtime required by the Table Data Import Wizard to import and load the three csv files containing the source data sets for my team's project.

Is there a way I can do this in the RDS tab on my Team's AWS account directly or some other way around having to go through MySQL Workbench perhaps? Or instead, should I install Microsoft SQL Server and create a new RDS db Instance using that engine instead?

Improve this question
9
  • 1
    Why does the CSV file have to go through the (presumably GUI) Workbench? When I want to load data into RDS PostgreSQL, I use the command line client; I bet the mysql cli client would be faster for your needs.
    – RonJohn
    Commented Apr 2, 2023 at 7:09
  • 1
    What’s the difference between this question, and the seemingly same question on SO? That answer told you not to use Workbench because it’s slow, and now you’re here asking why Workbench is so slow.
    – RonJohn
    Commented Apr 2, 2023 at 7:23
  • 1
    Have you pinged the db instance? More importantly, did you already create the indices on the Aurora database?
    – RonJohn
    Commented Apr 2, 2023 at 7:33
  • 1
    ping is just ping. You use it just like you'd ping any other device on a network. As for adding the indices... good. That slows down the import process.
    – RonJohn
    Commented Apr 2, 2023 at 13:36
  • 1
    Then "the network" might either be down or very problematic, and be a cause of the slowness. I'd next run WinMTR (a souped up combination of ping and traceroute.
    – RonJohn
    Commented Apr 6, 2023 at 10:52

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.