optimization - directories and sub-directories (with descendants)

2006-03-07 Thread Eli
Hi, I have a table of directories. Each row represents a directory, which holds his name and desc. Another table lists sub-directories from each directory source to its sub-directories targets. dirs: +--+--++ | dir_id | dir_name | dir_desc |

Re: optimization - directories and sub-directories (with descendants)

2006-03-07 Thread Peter Brawley
Eli, Example: I want to search on all the directories under 'd4' that contain the word music. I got several solutions, but not satisfying: A) Loop from 'd4' to sub-dirs in first level, and use buffer list for next iterations when going deeper into levels. [not good: there can be many