I'm wondering what method I should use for copying data from one table to another one. I'm letting users post data through a form which uses table1 to save data. Now for displaying results I use data from table2 but I also need some data from table1.
- Method 1: Copy the needed data on pageload, when the user executes it. Might get slower, but uses live data.
- Method 2: Use a cronjob. Less resources, but not live data
I'm interested in how much this will affect the speed of the website.