Re: Suggestion for optimization - reg
Hi,
-->5M rows? 1 Terabyte?
Yes
-->Normalization
I will do the required normalization.
-->Biometrics in another table
It is not possible. Because it is in production and the structure cannot be changed.
Many fields are there, which are not used at all. Means all rows for those columns contain "NULL" value. So kindly suggest, should I keep Default NULL or change to Default '0'.
-->Switching engine
I tried to switch to Innodb, but it gives "Storage engine error-139". Probably the table conatains more than the maximum column numbers allowed in Innodb engine.
--> Latina1 characterset
I do not have much knowledge about characterset. Kindly suggest a better character set.
Thanks & Regards,
Suvendu
Subject
Views
Written By
Posted
3165
January 23, 2012 05:09AM
1809
January 24, 2012 02:18AM
Re: Suggestion for optimization - reg
1764
January 24, 2012 06:50AM
1644
January 25, 2012 09:09PM
1701
January 25, 2012 11:04PM
1611
January 26, 2012 06:49AM
1565
January 26, 2012 02:48PM
2009
January 26, 2012 04:32PM
1729
January 27, 2012 08:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.