Hi, Thanks for the reply.
Currently We are using fulltext index search only. What I am looking forward is another effective way of doing it -- On Wed, 10 Apr 2002 15:15:08 Cathy Cunningham (Blue World Lasso Evangelist) wrote: >At 1:08 PM -0700 4/10/02, va ku wrote: >> >>We are developing a webbased serch application on MYSQL and PHP. I >>am sure most of you must have already implemented >>such application. Could you share with me the logic of such >>application. We were planning to keep a keyword search >>and my people feel that that will require additional load of >>keeping track of keyword and they are not interested in that. The >>other option is fulltext >>serch on all the data for one table, but concern about of the >>performance issue. >>Wondering how you guys are doing out there ? Which is the best way ? >>Any suggesstion appreciated . > >We need some more details to provide meaningful assistance. That >having been said, if you're going to be doing a project with massive >amounts of text and want to provide full text searching capabilities, >definitely take a look at MySQL v4 which provides some great >enhancements along the lines of full text indexing/searching. >Indexing is purportedly 100x faster and full text searching is >purportedly 2x faster. There's also a wealth of new search operators >planned (I don't know yet it they're implemented) which help with >defining the search. > >HTH > >CC >-- > >--------------------------------------------------------------------- >Cathy Cunningham [EMAIL PROTECTED] >Lasso Evangelist >Blue World Communications, Inc. http://www.blueworld.com/ >--------------------------------------------------------------------- > >Lasso Studio is "the easiest way to create a database-driven Web site" > - Macworld Magazine > See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
