I have a text file with over 800 million records all delimited and per line. I want you to import this in a mysql table in such a way that the database should work smoothly and return results very fast. It is a windows server 2012 with mysql workbench installed. So,
1) Design the database (There are 4 fields where first one needs to be searched)
2) Other three are numeric while first is text
3) I think you need to build index so design it accordingly. I need fast results
Let me know the time involved and how much you will charge. Since most of the time you will spend on importing don't charge me for days of work. I will give you RDP details.
Hi, How many RAM does the server has? How many fields do you want to index? You are going to need a big server to handle such amount of data in mysql. Regards, Sergio.