On Mon, Oct 10, 2005 at 06:28:23PM +0700, Ahmad Fajar wrote:
than you can index the field and you can gain better
perfomance in searching base on the fields, because the search uses the
index you have been created.
than you can index the field and you can gain better
perfomance in searching base on the fields, because the search uses the
index you have been created.
<, = or > comparisons, or LIKE 'foo%' with the C locale), but definitely not
all (it will help you nothing for LIKE '%foo%').
If you do not need to index the field, you can use the text field. Because
text field can store data up to 4 Gbytes.
So can varchar.text field can store data up to 4 Gbytes.
/* Steinar */
--
Homepage: http://www.sesse.net/
Homepage: http://www.sesse.net/
