Question re: updating a full-text index

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
voltrader
Forum Contributor
Posts: 223
Joined: Wed Jul 07, 2004 12:44 pm
Location: SF Bay Area

Question re: updating a full-text index

Post by voltrader »

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?
User avatar
Joe
Forum Regular
Posts: 939
Joined: Sun Feb 29, 2004 1:26 pm
Location: UK - Glasgow

Post by Joe »

I am sure you could use aliases to achieve what you desire?.
User avatar
voltrader
Forum Contributor
Posts: 223
Joined: Wed Jul 07, 2004 12:44 pm
Location: SF Bay Area

Post by voltrader »

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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

what's wrong with making the "source" table have full-text indexes on those fields?
Post Reply