MySQL Forums
Forum List  »  Full-Text Search

Re: Full text in INNODB
Posted by: Joost Schouten
Date: June 27, 2005 02:41PM

So do you mean you update your MyISAM full-text searchable table in real-time every time an insert/update is made to your INNODB tables?

If so, this is an intersesting approach. I would be very interested to hear your test results. And mainly on performance. As I can imagine inserting a LONGTEXT field on your INNODB aswell as your MyISAM will change your transaction execution time significantly.

My aproach would be to use a robot which will scan my InnoDB table periodically and update the MyISAM when it finds new/updated rows. But if your system works well and fast the real-time indexing would be great.

Keep us posted on your tests if you could.

Regards,
Joost

Joost Schouten
CEO - JS Portal
http://www.jsportal.com

Options: ReplyQuote


Subject
Views
Written By
Posted
27927
June 21, 2005 02:34PM
16558
June 22, 2005 10:52AM
14556
June 23, 2005 06:13AM
12951
June 24, 2005 06:42AM
12635
June 27, 2005 02:20PM
Re: Full text in INNODB
11989
June 27, 2005 02:41PM
10884
April 14, 2008 03:51AM
13191
July 06, 2005 08:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.