FW: varchar vs char - update statement

2006-10-30 Thread Julien Chavanton 

I have a database with several tables that can have up to 100 000 rows
there is ~100 updates every seconds and ~100 select query on the same
table using locks.

The update is always on the same field a varchar(15), I believe it will
be recommended to change it to char(15) to improve performance of the
update since the required space is not reserved with a varchar(15) type.

Is this assumption right?



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

varchar vs char - update statement

2006-10-26 Thread Julien Chavanton 
I have a database with several tables that can have up to 100 000 rows
there is ~100 updates every seconds and ~100 select query on the same
table with locks.

 

The update is always on the same field a varchar(15), I believe it will
be recommended to change it to char(15) to improve performance of the
update since the required space is not reserved with a varchar(15) type.

 

Is this right ?