: What method should I use for copying data from one table to another one? I'm wondering what method I should use for copying data from one table to another one. I'm letting users post data

@Bryan171

Depends on the amount of data.

If:


No large/weird/complex queries
No large datasets
Rowlocking (innoDB) instead of tablelocking (MyISAM)
No absurt amount of users/pagehits


Then you have no problem at all. Just make sure you index the right columns, and cleanup what you can so you dont get redundent data. If you're not sure when you should consider something 'a large dataset', you're not using a large dataset.

Easy answer: Just try and you'll see :).
But to my experience, the most influention factor is the queries themselves, just make sure those are right.



If you are talking about duplicating data, then please stop doing that! You can select info from two tables without ANY problem. Just use two queries, or a join.

Duplicate data is a big no-no in databases. 1 small column might provide a handy solution sometime, but always try the best you can to avoid it. This is a part of database normalisation.

Vote Up Vote Down