Hi,
I am developing application for multi-marketing. I need to search for entire down line for input "root" name. There may more than one direct down line under the root. A child can be the root of next level. Any method that can be used to identify the root (either searched before or not) that more effective?
I tried to delete the record for temporary, but it may take too long time. What is the optimised time usually needed for this which the root may have 10000 level of down lines?
What search method should be used ? SEEK or locate?

Thank you