It sounds like you are trying to do full text searching, but you
implemented it manually. Was MySQL's full text indexing not
sufficient for your needs or am I totally missing what you are trying
to do?
On Jan 15, 2004, at 1:53 PM, Gregory Newby wrote:
I'm using MySQL for an information
On Thu, Jan 15, 2004 at 02:52:30PM -0500, Brent Baisley wrote:
It sounds like you are trying to do full text searching, but you
implemented it manually. Was MySQL's full text indexing not
sufficient for your needs or am I totally missing what you are trying
to do?
You're absolutely right:
It looks like having a multiple-column index would help more than having
a number of individual indices, at least for the example query. An
index on (termid, docid, whichpara, offset) might work better than just
having one on termid.
joe
On Thu, 2004-01-15 at 10:53, Gregory Newby wrote:
I'm
Gregory
mysql,select,query
I agree with Joe, use multiple-column index. Much more efficient.
All queries should be sub 5-10 seconds or less.
David
-Original Message-
From: Gregory Newby [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 11:53 AM
To: [EMAIL PROTECTED]