MySQL multiple queries?
#3

The fact that's even necessary indicates that the database model isn't optimized. From the looks of it, it looks like you're trying to update a player's name in every table it appears in. However, a player's name should appear in the entire database just ONCE. All other features that need the player's name should refer to that name by its uniquely assigned id.

Also if you intend to execute a large sum of queries use transactions.
PHP код:
START TRANSACTION;
-- 
queries;
COMMIT
Reply


Messages In This Thread
MySQL multiple queries? - by EnforcerDon - 08.02.2015, 05:27
Re: MySQL multiple queries? - by Boooth - 08.02.2015, 08:43
Re: MySQL multiple queries? - by Vince - 08.02.2015, 11:41

Forum Jump:


Users browsing this thread: 1 Guest(s)