000 Table
entries and I have to do a keyword search HELP NEEDED
One
option that does not take advantage of any fancy indexing methods is to create
a trigger on the table, on insert/update/delete, which extracts each
individual word from the field you care about, and creates an entry
Borajetta,
The other thing you can do is take a look at your hardware. What are you
running this on? How much RAM? Are other things running on this server as
well?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)
in a
disk block.
-
Jeremy
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
borajettaSent: Monday, June 07, 2004 5:47 PMTo:
[EMAIL PROTECTED]Subject: [PERFORM] 50 000 000 Table
entries and I have to do a keyword search HELP NEEDED
S
Borajetta,
> So I have a table with about 50 million entries in it, I have to do a
keyword search.
Are you using OpenFTS/TSearch2? Is your database optimized?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
So I have a table with about 50 million entries in it, I have to do a
keyword search.
The keyword search is done on the title of the entry. For example a entry could be "This is a
title string which could be searched"
I have tried a few ways to search but I get horrible search times. So