Re: CHAR vs TEXT and fast Row Updates

2006-01-17 Thread Pooly
Hi, 2006/1/17, Karl Pielorz <[EMAIL PROTECTED]>: > > Hi All, > 1. Fixed length CHAR fields are quicker to update than VARCHAR fields > (because the field size is constant) There is no advantage if not all your field in your table are fixed size. as soon as you add a text/blob column, you loose t

CHAR vs TEXT and fast Row Updates

2006-01-17 Thread Karl Pielorz
Hi All, We have an application that needs to update rows in the database 'as fast and efficiently' as possible. To this end, we've tried re-designing the table - can someone clarify the following assumptions we're about to make? 1. Fixed length CHAR fields are quicker to update than VARCH