Guest_imported
New member
- Jan 1, 1970
- 0
Dear All
I want to be able to offer the user the ability to search, and then search the results they have returned.
I have it working but i don't think i have done it the most efficient way.
At the moment:
1. do initial search on whole db
2. build up a string of unique ids from search return
3. do secondary search on all db
4. apply a filter of the unique ids to the secondary search
This gives me the results i expect but is slow, i have tried including the unique ids in the secondary search sql but i end up with problems when the sql gets too long.
Any advice much appreciated. [sig][/sig]
I want to be able to offer the user the ability to search, and then search the results they have returned.
I have it working but i don't think i have done it the most efficient way.
At the moment:
1. do initial search on whole db
2. build up a string of unique ids from search return
3. do secondary search on all db
4. apply a filter of the unique ids to the secondary search
This gives me the results i expect but is slow, i have tried including the unique ids in the secondary search sql but i end up with problems when the sql gets too long.
Any advice much appreciated. [sig][/sig]