Hi there,
I have now installed SphinxSE as an additional search engine to MySQL. This engine as you may already know uses its own indexing to search for documents. I am now looking into the PT where to 'turn off' the indexing.
Many Thanks.
Bob
Hi Bob,
That particular SQL doesn't create the index, it only uses it (and requires it). The index is built up automatically by the database (not the script) during import; so if you've dropped the fulltext index it will no longer be created...
Cheers,
David.
I see. I thought it was PT that was giving instructions to create or not to create indexes. So there is no way to turn this indexing off by MySQL before import of data?
Many Thanks.
Bob
Hi Bob,
No - it's all automatic simply based on whether or not the index exists. If it's there - MySQL will build it; if not - it simply does a normal import.
Cheers,
David.
Right. I understand now. I have to understand one more thing as I try to link tables. There is a requirement for my tables to have id with "UNIQUE UNSIGNED NON-ZERO 32-BIT INTEGER". Does this part if sql statement in the PT = "id int(11) NOT NULL auto_increment" create something like:
1
2
3
4
against documents?
Many Thanks.
Bob
Hi Bob,
That's correct - you can use the "id" field which fits that requirement.
Cheers,
David.
Hello Bob,
As you will have to make changes to the code anyway, I think the easiest thing to do is simply to DROP the FULLTEXT indexes from the products table using a MySQL admin tool. This will of course break the main search SQL that uses the MATCH (xxx,xxx) AGAINST (xxx,xxx) syntax (which is specific to the FULLTEXT index) - but that means it's easy to pinpoint where you need to make the code changes - around about line 65 of search.php...
Cheers,
David.