Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
voltrader
Forum Contributor
Posts: 223 Joined: Wed Jul 07, 2004 12:44 pm
Location: SF Bay Area
Post
by voltrader » Sat Feb 26, 2005 3:47 pm
I've been keeping my full-text index updated by emptying it, and rebuilding it using
Code: Select all
insert INTO full-text_index
SELECT c1, c2, c3
FROM temp_stuff
Can use an UPDATE instead for a full-text index?
Joe
Forum Regular
Posts: 939 Joined: Sun Feb 29, 2004 1:26 pm
Location: UK - Glasgow
Post
by Joe » Sat Feb 26, 2005 6:26 pm
I am sure you could use aliases to achieve what you desire?.
voltrader
Forum Contributor
Posts: 223 Joined: Wed Jul 07, 2004 12:44 pm
Location: SF Bay Area
Post
by voltrader » Sat Feb 26, 2005 8:59 pm
Pretty cryptic response Joe...
Let me elaborate: I often have updates in another table that need to be inserted into the fulltext table for search purposes. I currently empty and then rebuild my full-text search index in the dead of night because I don't want my db to be offline during busier times. Is there no other way than to empty and then rebuild?
That seems kludgy.
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Sat Feb 26, 2005 9:02 pm
what's wrong with making the "source" table have full-text indexes on those fields?