> -----Original Message----- > From: Sujay Koduri [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 22, 2005 15:23 > To: mysql@lists.mysql.com > Subject: Avg row length is varying a lot from oracle to MySQL > > > hi ,, > > we are converting our oracle DB to MySQL DB. One problem i > see is that the > > abg row length in MySQL is much higher compared to that of Oracle. > > In oracle it is around 180 bytes and in MySQL it is around > 686 bytes. So as > > a result, MySQL is taking more space to store the same number > of records. > > Can someone please explain me if this is the intended > behaviour or i am > > missing out something. I am also including the o/p of desc > table_name of the > > same table on both the databases.
Probably do to the way the two database store data and how much space they reserve for specific column types. For a way to calculate row size see this link. Relize you must also calculate the size of all indexes. http://dev.mysql.com/doc/mysql/en/storage-requirements.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]