tag:blogger.com,1999:blog-13606853.post1240428351613955110..comments2023-12-28T16:01:32.344+05:30Comments on Whatever....: realtime fulltext indexgamegeekhttp://www.blogger.com/profile/00557771372755358783noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-13606853.post-57415690573962708602007-05-14T20:52:00.000+05:302007-05-14T20:52:00.000+05:30The solution suggested by phil is the ultimate sol...The solution suggested by phil is the ultimate solution - what i call as "divide and rule". But it has to be designed in a manner that resource usage is minimized. <BR/><BR/>And each application has specific needs which needs special designing to satisfy its needs and keep the app up and running...<BR/><BR/>So, lets c..gamegeekhttps://www.blogger.com/profile/00557771372755358783noreply@blogger.comtag:blogger.com,1999:blog-13606853.post-33027759646253556022007-05-14T20:40:00.000+05:302007-05-14T20:40:00.000+05:30hmm..so mysql inserts are too slow, senna does not...hmm..so mysql inserts are too slow, senna does not give any improvement, sphinx is too limited, and lucene takes time to integrate...so have you tried out phil's suggested solution till now??Shiprahttps://www.blogger.com/profile/10991382073985109041noreply@blogger.comtag:blogger.com,1999:blog-13606853.post-56807868480424607372007-05-14T15:20:00.000+05:302007-05-14T15:20:00.000+05:30Choose a way to partition the data - split it out,...Choose a way to partition the data - split it out, make a lookup table to find out where it is, and make a load of small tables. Then you have a real-time index :)filhttps://www.blogger.com/profile/01068253084652858363noreply@blogger.com