Re: MySQL maximum row size?

Stephan Engelke wrote: > ~~~~~ > Is there any reason why one should not use blobs to store > Question/Answer pairs (one blob each)? > You know your data, but it would seem if you could use varchar it might be better. But that depends on what kind of queries your going to be doing. Like left joins. Read the section in the manual on 'EXPLAIN', and that'll show you some of the considerations to take into account. But if these are large, the other option is 'text' and you might want to read up on the differences between the two. Not much, I don't think, but might make a difference on searching, indexing? Mike D./ no wiz on this.