I got a search situation as the following: User passes me the search condition parameters, like search based on author name, keywords, or anything user like. The search returns the list of document records. Then from these document records, I need to find out the first 200 items of special notes, some articles may not have special notes, some articles may have more than 1 special notes. The requirement is: I need to return the first 200 special notes no matter how many document records I have to go through. So I cannot put pagination on the search result.
I have a concern: if the search is very wide range and the search returned a large list of document records, let's say search returned 3000 document records, then I need to loop through these 3000 records until I found 200 special notes. The search returns document records, does that mean once search returned, these document records are in memory? Or if not in memory, does that mean if I only looped from 1 to 200 document records and then stop the loop, then the rest 2800 document records won't affect the memory? No matter what, reading 200 document records into memory for one search is a lot, is there any other ways that I can do to improve the search? Any thoughts and ideas are appreciated. Thanks, Helen _______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
