Hi Everyone, I hope someone can advise here - we have an opportunity to work with a large company who need data extracting from a database with 700,000 records in it. We have a meeting on Friday which could be make or break for our company.
We have been trying to import an 80 MB csv file into a MySQL database using phpmyadmin and it's taking a very long time to upload the file. We have tried every variant of csv file that we can think of and they all either take ages to upload or just crash. When we have managed to upload a file, a simple query takes 15 minutes or more to run.
The table has 22 columns, are we expecting too much from phpmyadmin and mySQL or should this be a simple job for it? Any advice would be greatly appreciated.