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:

Error, 101 a DNS problem ? (1997) [CART] inside a [LOOP] (1997) OT. Self explanatory (2003) automatic reload of frameset (1997) Setting user and password (1999) RE: Promise of future help (1998) Stop the madness. (1997) Performance: deafening silence (1999) [Semi-OT] Eaaaaaasy OSX FTP (2003) Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) refresh (2000) Help name our technology! (1997) Plugin or CGI or both (1997) Still Pulling my hair out (2001) Shopping Cart Problem (1998) question... no field names? (2002) WebCatalog can't find database (1997) Adding a product from another site (1997) [slightly OT] WebCat vs. WebObjects ;) (2000) mac hack (1997)