Re: why size of table c united from table a and b are bigger than a+b ?

The default charset of c is utf8, and that of a and b is latin1. Maybe charset cause size of table increased? -- Thanks & Regards Chylli Of course this is it ! Latin1 needss one byte per character ... while utf needs from 1 to 3 bytes per character. Still the rate of growing 1,9 can only be ex

Re: why size of table c united from table a and b are bigger than a+b ?

A good idea, thanks very much. -- Thanks & Regards Chylli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: why size of table c united from table a and b are bigger than a+b ?

chylli wrote: chylli <[EMAIL PROTECTED]> writes: Chris <[EMAIL PROTECTED]> writes: Because you're adding all columns from a and b into it. It is too slow. Has anyone better methods to do that work? Drop the indexes on c and create them at the end. Each row that's being added, it's updating

Re: why size of table c united from table a and b are bigger than a+b ?

The default charset of c is utf8, and that of a and b is latin1. Maybe charset cause size of table increased? -- Thanks & Regards Chylli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: why size of table c united from table a and b are bigger than a+b ?

chylli <[EMAIL PROTECTED]> writes: > Chris <[EMAIL PROTECTED]> writes: > >> >> Because you're adding all columns from a and b into it. >> >>> It is too slow. Has anyone better methods to do that work? >> >> Drop the indexes on c and create them at the end. >> Each row that's being added, it's upda

Re: why size of table c united from table a and b are bigger than a+b ?

Chris <[EMAIL PROTECTED]> writes: > chylli wrote: >> I run following command : >> use db1; >> insert into db2.c select a.a, a.b, a,c, b.d, b,e ... from a left join b on >> (a.id=b.id); > > Do you have an index on a.id and b.id ? > >> size of table a and table b is: >> [EMAIL PROTECTED] ls -l ../db

Re: why size of table c united from table a and b are bigger than a+b ?

chylli wrote: I run following command : use db1; insert into db2.c select a.a, a.b, a,c, b.d, b,e ... from a left join b on (a.id=b.id); Do you have an index on a.id and b.id ? size of table a and table b is: [EMAIL PROTECTED] ls -l ../db1/a.* -rw-rw 1 mysql mysql 9230 May 10 15:41

why size of table c united from table a and b are bigger than a+b ?

I run following command : use db1; insert into db2.c select a.a, a.b, a,c, b.d, b,e ... from a left join b on (a.id=b.id); size of table a and table b is: [EMAIL PROTECTED] ls -l ../db1/a.* -rw-rw 1 mysql mysql 9230 May 10 15:41 ../db1/a.frm -rw-rw 1 mysql mysql 880880528 Jul 17 01