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 sorting performance in a big way. Also, searching by date can be slow because so much interpretation is required of mm/dd/yyyy fields. You can get as much as a 10x improvement on date searches if you reformat them to be text-sortable as yyyymmdd. Also, case-sensitive text searches help somewhat.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: How is it done? (Kenneth Grome 1998)
  2. Re: How is it done? (PCS Technical Support 1998)
  3. Re: How is it done? (PCS Technical Support 1998)
  4. Re: How is it done? (Trevor Crist 1998)
  5. Re: How is it done? (Kenneth Grome 1998)
  6. Re: How is it done? (Kenneth Grome 1998)
  7. Re: How is it done? (PCS Technical Support 1998)
  8. Re: How is it done? (Kenneth Grome 1998)
  9. Re: How is it done? (PCS Technical Support 1998)
  10. How is it done? (Kenneth Grome 1998)
>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 sorting performance in a big way. Also, searching by date can be slow because so much interpretation is required of mm/dd/yyyy fields. You can get as much as a 10x improvement on date searches if you reformat them to be text-sortable as yyyymmdd. Also, case-sensitive text searches help somewhat.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/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)