Can someone guide me on the best or fastest way to add 2 tables together please?
Currently i am building an application locally on my laptop, i want to try and get it right before i hand it over to the administrator to put it on the server.
There are over 40 million records currently on our server which will need to be reloaded into this app, and obviously the data is increasing daily, so i am looking for the best way to add 2 tables together.
The tables have 20+ fields and roughly half of the fields have the same field names.
Joining these two sources will lead to a table with a lot of NULL values, since they do not share all fields. Could you provide a sample of data to demonstrated what the resulting table should looks like, since this determines what you should do in order to get the desired result?
If you've got 40 million records don't be shocked if you run out of memory... my laptop can't load ~21 million rows (~2gb csv). It can load stuff from that file with WHERE clauses but it can't actually load all 21 million rows.