[Answer]-Big mysql query versus an http post connection in terms of long term speed

It depends a lot on what you plan on doing with the data. However, thinking long term you’re going to have much more flexibility with breaking out the friends into distinct units than just storing them all together.

If the friend creation process is taking too long, you should consider off-loading it to a separate process that can finish it in the background, using something like Celery.