Sedang Disiapkan

221023 Full Text Search in mysql

On a database of 100,000 entries, implement full text search on the title and description fields. The table and fields that need to be search are

| Field | Type | Null | Key | Default | Extra |

+-------------------+---------------+------+-----+---------+-------+

| entry_unique_id | varchar(32) | NO | PRI | | |

| category_id | int(11) | NO | MUL | 0 | |

| location_id | int(11) | NO | MUL | 0 | |

| xml_entry_title | varchar(1024) | NO | | | |

| xml_entry_descr | text | NO | | | |

| xml_entry_link | varchar(255) | NO | | | |

| xml_entry_pubdate | int(11) | NO | |

the xml_entry_title and xml_entry_descr fields. The description field has a maximum lenght of 500 characters.

The search function should be optimized for search, rather than updates, and cacheing searches should be part of the solution.

Please supply harness scripts to test the solution with a list of queries terms in a file. I will supply the database table, and will run benchmark tests on the speed.

Please do not bid if you have no full-text-search experience.

Kemahiran: Semua Boleh, MySQL

Lihat lebih lanjut: text 500, search for solution, c text search, speed type test, mysql test, mul, harness, mysql characters, mysql search table, search terms, mysql search database table, function search, search solution, text table, search extra fields, extra field search, full text, default search , search field extra, full list, text search, search optimized, 500 entries database, search title, type speed test

Tentang Majikan:
( 163 ulasan ) London, United Kingdom

ID Projek: #1967258