I think the schema here needs a little tweaking. This is a perfect case for a many to many relationship also know as a bridge table.
You have table 1 which is your for processes and you have table 2 for your tasks. You will need a table 3, which will store the primary key from processes and tasks, so that all you are searching on are quick and small data sets that represent the permutations of not repeated data. tblProcess --------------- processID .... tblTask ----------- taskID .... tblProcessTask ----------------------- processTaskID processID taskID Makes sense? Cheers, Teddy On 1/8/07, Tom Chiverton <[EMAIL PROTECTED]> wrote: > > On Saturday 06 January 2007 21:20, Jochem van Dieten wrote: > > index scales with the natural logarithm of the cardinality so 4000 > > composite records should only be 1.5 times slower then 900 individual > > And, tbh, if your database can't sort 4000 records in reasonable time, you > have other problems :-) > > -- > Tom Chiverton > Helping to appropriately syndicate strategic relationships > > **************************************************** > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in England > and Wales under registered number OC307980 whose registered office address > is at St James's Court Brown Street Manchester M2 2JF. A list of members is > available for inspection at the registered office. Any reference to a > partner in relation to Halliwells LLP means a member of Halliwells LLP. > Regulated by the Law Society. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above and > may be confidential or legally privileged. If you are not the addressee you > must not read it and must not use any information contained in nor copy it > nor inform any person other than Halliwells LLP or the addressee of its > existence or contents. If you have received this email in error please > delete it and notify Halliwells LLP IT Department on 0870 365 8008. > > For more information about Halliwells LLP visit www.halliwells.com. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
