Re: &max=

This WebDNA talk-list message is from

2003

It keeps the original formatting. numero = 52979
interpreted = N
texte = >> there is no efficiency by using the max parameter. Are searches faster if>> one uses the max parameter or not?No.>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.Yes.>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.Yes. It might be fun to write your own indexing for a database and use it with rank=off do text comparisons. This would be particularly helpful with dates. Of course, just use a real SQL database at that point.-- --------------------------------- John A. Hill Oak Hill SoftwareWebsite Development/Consulting john@oakhillsoftware.com-------------------------------------------------------------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)