Re: How is it done?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17448
interpreted = N
texte = >Searching records with multiple values seems to be taking a very long>time. I know that part of the problem is because it's a 250,000 record>database and I'm running on a 68040 MacDo you have VM turned on? If so, that can affect searching and sortingperformance in a big way. Also, searching by date can be slow because somuch interpretation is required of mm/dd/yyyy fields. You can get as muchas a 10x improvement on date searches if you reformat them to betext-sortable as yyyymmdd. Also, case-sensitive text searches helpsomewhat.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>Searching records with multiple values seems to be taking a very long>time. I know that part of the problem is because it's a 250,000 record>database and I'm running on a 68040 MacDo you have VM turned on? If so, that can affect searching and sortingperformance in a big way. Also, searching by date can be slow because somuch interpretation is required of mm/dd/yyyy fields. You can get as muchas a 10x improvement on date searches if you reformat them to betext-sortable as yyyymmdd. Also, case-sensitive text searches helpsomewhat.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
Editor Recommendation for NT Users (1998)
Help HTML reader (1999)
Multiple fields on 1 input (1997)
Server crash (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
SiteGuard Admin Feature ? (1997)
combine search (1998)
[lineitems] and [writefile] (1998)
New index for docs (1997)
WebCat2.0 acgi vs plugin (1997)
PIXO (1997)
READFILE command? (1998)
OFF-TOPIC: For Gary Krockover ... (2003)
ShowNext (1997)
my price won't move (1997)
[CART] (1997)
[WebDNA] Alt Web Servers OS X (2011)
Email Line Breaks (2003)
[cart] not being interpreted inside [founditems] (1997)
two part electronic product (1998)