John Hansen wrote:
On Tue, 2004-10-19 at 13:24, Joshua D. Drake wrote:
I have a database now with 1.77 million entries using Tsearch. The
entries are book titles. It runs
very well. There are some tricks to it though. For example what we had
to was have a single
table that has nothing but a product_id, title, title_vectors.
Ok, i'm guessing none of the titles are as long as an email... what's
the speed like?
1.4 seconds for the search, 4.5ms for the pull of the full details..
So no -- that may not scale that well. We would have to test it out.
Sincerely,
Joshua D. Drake
... John
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
