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:
Quick poll (2003)
[OT] maximum POST variable size (2007)
Exclamation point (1997)
OT: Urgent help with Windows and Javascript (2003)
Attn: Bug in GeneralStore example b15 (1997)
[WebDNA] site becomes unavailable and WebCatalog warnings (2017)
Cool new site (1996)
Re: (1998)
Sorta OT: Printing From Browser Window (2001)
HELP WITH DATES (1997)
OK, here's a new one (2002)
Trouble with formula.db (1997)
maximu values for sendmail! (1997)
emailer prob (1998)
Time code! (2002)
Customizing WebDelivery.html (1998)
PCSDecrypt bugs still unfixed ... (2000)
More help for discount pricing (1998)
Public beta 6 for WebCatalog 4.0 is now available (2000)
[group] ? (1997)