I've set up a database containing 10.000 main records. However, there are LOTs of n:m-relationship tables surrounding the main table. Now I want to set up an efficient search through the whole datamodel. ==> I've got lots of SELECT id, title from main LEFT JOIN subtable1 ... LEFT JOIN .... WHERE subtable1.value1="xy" or .... ==> this kind of JOINing means that there's furious proliferation of records, each JOIN resulting in a multiplied set of records to finally match the AND/OR-conditions. ==> It works, but does anybody have any suggestions on how to improve the behavior? Unfortunately a simple ftsearch is not possible, because the n:m-relationships would have to be resolved to their title stored in other tables. Best regards, Johannes Fiala Email: [EMAIL PROTECTED]
