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
3396
January 23, 2012 05:09AM
1941
January 24, 2012 02:18AM
Re: Suggestion for optimization - reg
1888
January 24, 2012 06:50AM
1785
January 25, 2012 09:09PM
1853
January 25, 2012 11:04PM
1738
January 26, 2012 06:49AM
1684
January 26, 2012 02:48PM
2130
January 26, 2012 04:32PM
1842
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.