Re: [PERFORM] seeking advise on char vs text or varchar in search table

2007-04-26 Thread Gregory Stark
"Jim Nasby" <[EMAIL PROTECTED]> writes: > AIUI, char, varchar and text all store their data in *exactly* the same way in > the database; char only pads data on output, and in the actual tables it > still > contains the regular varlena header. The only reason I've ever used char in > other datab

Re: [PERFORM] seeking advise on char vs text or varchar in search table

2007-04-26 Thread Jim Nasby
On Apr 23, 2007, at 7:16 AM, Merlin Moncure wrote: On 4/20/07, chrisj <[EMAIL PROTECTED]> wrote: I have a table that contains a column for keywords that I expect to become quite large and will be used for web searches. I will either index the column or come up with a simple hashing algorit

Re: [PERFORM] seeking advise on char vs text or varchar in search table

2007-04-22 Thread Merlin Moncure
On 4/20/07, chrisj <[EMAIL PROTECTED]> wrote: I have a table that contains a column for keywords that I expect to become quite large and will be used for web searches. I will either index the column or come up with a simple hashing algorithm add the hash key to the table and index that column.

[PERFORM] seeking advise on char vs text or varchar in search table

2007-04-22 Thread chrisj
I have a table that contains a column for keywords that I expect to become quite large and will be used for web searches. I will either index the column or come up with a simple hashing algorithm add the hash key to the table and index that column. I am thinking the max length in the keyword col