Sorting by highest number of matches unique to a field
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52124
interpreted = N
texte = This has kind of been touched on lately in the thread "Total found of each unique field" started by Gary Krockover, but I was hoping to get a clearer understanding of the possibility of sorting a search by entries that have the most number of matches first. For example, I have a message board database. Each thread in the board has a [msg_id] (which is a cart value), and each post to that thread, has a [msg_rank], starting at 0 and on up to the last post in that thread. I want to add a functionality so the users can be able to go to an area where they can view the most popular threads. This particular database has about 24,000 posts under about 3,000 threads, and is about 11MB. So, I want to search it and sort it / sum it by the threads that have the most posts, in order to show the most popular topics first. It is my understanding that you can not sort the highest number of matching fields with a conventional search and sort, but you have search the entire database, and get a [numfound] on each thread, then write those results to a temporary database with the [msg_id] and the [numfound] for that msg, then search that temporary database, and sort numerically the results of the [numfound] field (whatever it's name is)... I don't really have a problem with doing it that way, other than the database is getting rather large, and I'm worried about the processor load, everytime someone uses that option, and the system has to write 3000 entries (and increasing daily) to a temp database. does anyone have experience with this sort of thing, and have any suggestions, or advice? Am I missing something, or is this the best approach? It seems like a lot of crap to go through to find the best ranking group of founditems. Maybe what I'm looking for is a way to sort [founditems][/founditems] rather than a way to sort a search? Ughhh! -Robert ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
This has kind of been touched on lately in the thread "Total found of each unique field" started by Gary Krockover, but I was hoping to get a clearer understanding of the possibility of sorting a search by entries that have the most number of matches first. For example, I have a message board database. Each thread in the board has a [msg_id] (which is a cart value), and each post to that thread, has a [msg_rank], starting at 0 and on up to the last post in that thread. I want to add a functionality so the users can be able to go to an area where they can view the most popular threads. This particular database has about 24,000 posts under about 3,000 threads, and is about 11MB. So, I want to search it and sort it / sum it by the threads that have the most posts, in order to show the most popular topics first. It is my understanding that you can not sort the highest number of matching fields with a conventional search and sort, but you have search the entire database, and get a [numfound] on each thread, then write those results to a temporary database with the [msg_id] and the [numfound] for that msg, then search that temporary database, and sort numerically the results of the [numfound] field (whatever it's name is)... I don't really have a problem with doing it that way, other than the database is getting rather large, and I'm worried about the processor load, everytime someone uses that option, and the system has to write 3000 entries (and increasing daily) to a temp database. does anyone have experience with this sort of thing, and have any suggestions, or advice? Am I missing something, or is this the best approach? It seems like a lot of crap to go through to find the best ranking group of founditems. Maybe what I'm looking for is a way to sort [founditems][/founditems] rather than a way to sort a search? Ughhh! -Robert ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Robert Wade
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
RE: Languages (1997)
thisurl & arguments (2000)
[WebDNA] Different settings on old vs new admin pages (2010)
2.0 Info (1997)
Location of Browser Info.txt file (1997)
Summary layout (1997)
Protect (1997)
cookies and [returnraw] (1997)
Saving [referrer] for later use (1997)
Comments in db? (1997)
WebCat2 as a chat server? (1997)
Using Applescript to process WebCatalog functions (1998)
Generating Report Totals (1997)
Multiple prices (1997)
Multiple catalog databases and showcart (1997)
webdelivery.html and webna (1997)
Tracking E-mail click thrus (2001)
formulas.db ?? (1998)
[WebDNA] HTML mail (2012)
Re:Formulas.db / Quantity Discount problem (1998)