MYSQL Database creating.
#7

Quote:
Originally Posted by Extremo
Посмотреть сообщение
EDIT: It might be useful to mention that you can actually do something called CREATE TABLE IF NOT EXISTS - which you can use to make sure your gamemode always creates the tables when they don't exist and no longer have to worry about wether they exist in the first place.
This is extremely wasteful considering that those will probably only be executed once in the lifetime of the server.

If the database is normalized and has indexes and keys assigned appropriately (rather than just a table "players" with 300 fields) then it will be very hard to just create it out of the blue. Check the script if any queries use the keyword "JOIN".
Reply


Messages In This Thread
MYSQL Database creating. - by fonia5 - 22.02.2015, 07:23
Re: MYSQL Database creating. - by HydraHumza - 22.02.2015, 07:24
Re: MYSQL Database creating. - by Extremo - 22.02.2015, 07:29
Re: MYSQL Database creating. - by CalvinC - 22.02.2015, 07:30
Re: MYSQL Database creating. - by fonia5 - 22.02.2015, 07:46
Re: MYSQL Database creating. - by Extremo - 22.02.2015, 08:21
Re: MYSQL Database creating. - by Vince - 22.02.2015, 09:43
Re: MYSQL Database creating. - by Extremo - 22.02.2015, 09:47
Re: MYSQL Database creating. - by muzammilfreeman - 22.02.2015, 10:19

Forum Jump:


Users browsing this thread: 4 Guest(s)