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

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 the