Doubt regarding database performance
#2

Quote:
Originally Posted by SupremeCommander
Посмотреть сообщение
100 columns
I stopped reading right there. If you have this many columns in a single table then that's usually a sign that your database isn't properly normalized, or not normalized at all. Normalization means restructuring the database to avoid duplicate data and empty values.

Please provide the list of columns so I can help you normalize your database.
PHP код:
SHOW CREATE TABLE tableName 
Then expand options and enable fulltext.

I wish NULL values would be properly supported by SA-MP, but unfortunately they are fetched as if they were a string, which is problematic if you have a NULL value in a non-string field.
Reply


Messages In This Thread
Doubt regarding database performance - by SupremeCommander - 21.12.2014, 18:43
Re: Doubt regarding database performance - by Vince - 21.12.2014, 19:21
Re: Doubt regarding database performance - by SupremeCommander - 21.12.2014, 19:53
Re: Doubt regarding database performance - by PowerPC603 - 21.12.2014, 21:00
Re: Doubt regarding database performance - by SupremeCommander - 22.12.2014, 08:10
Re: Doubt regarding database performance - by PowerPC603 - 22.12.2014, 21:19

Forum Jump:


Users browsing this thread: 2 Guest(s)