On Sun, Jul 19, 2009 at 9:46 PM, Robert James wrote:
> I'm storing a lot of words in a database. What's the fastest format for
> finding them? I'm going to be doing a lot of WHERE w LIKE 'marsh%' and WHERE
> w IN ('m', 'ma'). All characters are lowercase a-z, no punctuation, no
> other alphabets.
Is there a way to use a more compact encoding? I only need 4 bits per char -
that would certainly help caching. (I have indexes tuned very well,
already).
On Mon, Jul 20, 2009 at 2:02 AM, Peter Eisentraut wrote:
> On Monday 20 July 2009 04:46:53 Robert James wrote:
> > I'm storing a lot of word
On Monday 20 July 2009 04:46:53 Robert James wrote:
> I'm storing a lot of words in a database. What's the fastest format for
> finding them? I'm going to be doing a lot of WHERE w LIKE 'marsh%' and
> WHERE w IN ('m', 'ma'). All characters are lowercase a-z, no punctuation,
> no other alphabets.
I'm storing a lot of words in a database. What's the fastest format for
finding them? I'm going to be doing a lot of WHERE w LIKE 'marsh%' and WHERE
w IN ('m', 'ma'). All characters are lowercase a-z, no punctuation, no
other alphabets. By default I'm using varchar in utf-8 encoding, but was
won
