Re: &max=

This WebDNA talk-list message is from

2003

It keeps the original formatting. numero = 52966
interpreted = N
texte = William DeVaul wrote:> That the search results returns a numfound for a full search suggests that> there is no efficiency by using the max parameter. Are searches faster if> one uses the max parameter or not?The &max parameter is a limit on the number of records returned, not the number of records found. The reason for that is very simple: WebCatalog uses a complicated algorythm to return records in a "best fit" order. Then the &max makes sure that only that many records are returned (as others pointed out it is usually to display x records per page).Even if you specify a different sort order, WebCatalog still has to do a full table search in order to generate the order, before returning only the first &max records. The only time you could truly optomize it is to use the random sorting, where the first &max records which match the criteria are returned immediately (i.e. without searching the whole table).However, this would likely vastly complicate the search code for what is usually a minor edge case. I believe that even in the random sort order, WebCatalog still collects together all of the records that meet the criteria given, then randomly chooses from that list to return up to &max records.This is very different from an index driven database (like SQLServer or Oracle), where a search that can be made on the indexed columns only will be much faster.HTHJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4501 Forbes BoulevardSuite HLanham, MD 20706301-459-3366 x.5010fax 301-429-5748-------------------------------------------------------------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:

[WebDNA] Parsing JS value to WebDNA variable or (Palle Bo Nielsen 2018)