Author: brent
Email: [EMAIL PROTECTED]
Message:
I need to index the fields of an existing MySQL table. (I'm not scanning websites).
The table will have about 1 million rows in it and I need fast text retrieval,
something like MySQL's FullText index. So the user will enter one or more words, and
it should return the records sorted by the highest ranking records first.
Before downloading & installing MnoGoSearch I have a few questions that I need
answered to make sure it will do what I think it will do.
1) Can MnoGoSearch index an InnoDb table? (MySQL table with Type=InnoDb)
2) Does MnoGoSearch work with MySQL 4?
3) To index the fields of a table, do I have to put all of the fields I want to index
in the one table? Or can I have a secondary table that is linked by a foreign key?
Example:
Table1: Employees
Fields: Employee_Id, Employee_Name, Dept, Boss, HireDate
FK: Addr_Id
Table2: Addresses
Fields: Addr_Id, Street, City, Country, Phone
FK: Employee_ID,
So if the search has the person's address "123 Park Street" I'd like it to return info
from both tables like Employee_Name, Dept, Phone etc. Can MnoGoSearch do this? Or does
all of the data have to be in the one table? TIA
Brent
Reply: <http://www.mnogosearch.org/board/message.php?id=3523>
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
