Hi guys I need the help from a programmer who has extenive knowledge in PHP and MySQL. I will pay $150 for the job. Please read below before responding to me. Requirements The programmer must be available right now and work only on this job as it is quite urgent. The programmer must be able to work with large amounts of data and have no bandwidth issues. My Site My website consists of about 70 databases, all ranging from 10mb to a few Gigs. There is about 200 000 000 records in total between the databases. All databases have various fields and they are not the same. (This is where my problem lies) Visitors can search on data and certain records will be returned to my visitors. What I Need: 1. The programmer must be able to create 3 or more new database with only the fields I require and draw all data from all the databases into the new databases. (I do not need all the data and fields in all the current databases). 2. Currently my search results take up to 10 minutes to draw results and the new database must be optimized to work much faster. 3. I need the programmer to write a new script for searching the databases and displaying results. There must be hyperlinks to other data sources if there are other results. (I will explain this requirement to the coder). 4. The new script must be implemented back into my current website. If you think you can do this, I will pay you $150 for the job if successfully completed.
The easiest is to let each database be seperate and ask the user which database they wish to search (checkbox/radio button). Then connect to that database and do the search. For the 10 minute problem, it's not the database, it's your code Thanks