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 --------------------------------------------------------------------- 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
