MX Kollection Forum :: fulltext search with many-to-many table relation

This thread was displayed: 0 times


Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.

For more information about the affected products visit: www.interaktonline.com/Support/

View Threaded Show descending
antonio
04-16-2009 11:36:20 GMT +2

Hi all, I'm trying to find a way to filter a recordset using fulltext search over three tables related with a many-to-many relation. But I get timeout errors every time I try to do a search. 

Here is the table structures: 

main product table: 4.000+ rows

linking table: 4.000+ x 3 rows (12.000+ rows) 

related (language) table: 3 rows 

The main table is linked to the related table by product_ID. 

The linking table has a link to the related (language) table: language_ID. 

Products table          linking_table                      related table 

product_id ---------->prodid_lnk

                                language_lnk<-------------- langid_lnk

                                translation_lnk

                                keywords_lnk

I would like to find products with specific keywords (I enter the searched keyword in another page/search form) and possibly using the same keyword to filter other fields (fields in product5 table and fields in linking table).


Is this possible?

TIA


tony
Back | Reply | Quote | Top
Forums
© Adobe Systems Romania. All rights reserved.