MYSQL Database creating.
#8

Quote:
Originally Posted by Vince
Посмотреть сообщение
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".
How is this wasteful? It's maybe five queries or ten in the start of a gamemode. No harm done. It's done in an instant for mysql. This was purely assuming you move to a different server one day and don't have to migrate your data. Either case, if you want to be that picky, simply wrap a pre-processor define around it and you're set. I hardly find this wasteful. Wasteful is developing a gamemode and wasting people's time trying to figure out your database structure.
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: 3 Guest(s)