Need to put over 300,000 record table on a website. Now my concern is importing it and managing it on MySQL using one of these average PHP/MySQL shared hosting setups where you can only manage through phpMyAdmin. I had a problem with this one site when I have to import only 4000 records using the csv file upload feature with phpMyAdmin. It would time out before it was done. I am afraid of how to deal with 300,000 records.
My other option is going with a web hosting company that offers MS SQL Server, but I would rather not because I like the web based admin of phpMyAdmin.
Question. Does anyone else manage/import MySQL tables with 300,000 + records through phpMyAdmin and not have a problem with it? If so, what web hosting company are you going through? Or should I just bite the bullet and go with MS SQL Server for tables this large?
Thanks for any advice