Re: Large databases in WebCat
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14489
interpreted = N
texte = >I do, however, have some questions about RAM & cache settings for >WebStar and WebCatalog. What settings are the most important for >speed? The actual inventory file is 20 Megs. There're other database >files such as details, options, etc. Make sure there is enough RAM allocated such that WebCatalog never has to unload 1 database to load another. Use About This Computer from the Finder to watch how much RAM is being used, and perform a search on a big database. Watch the RAM bar go up, then do a search on your other databases (if any) and if the RAM bar goes *down* then you it has unload the first database to get the second into RAM. Give it more RAM if this happens.Turn on Template Caching in your preferences to reduce disk hits. Tab-delimited databases import a little bit faster than Merge format.>Also, are there ways of writing the search string to improve performance >(ie put the most limiting field for the search first to drastically >reduce records being compared for subsequent field criteria)?[Lookup] is a special-case search that is the fastest, because it does an exact match (case-sensitive) on one field only. Use it for finding a particular SKU or password or things like that.For general searching, setting rank=off will cause it to not spend time sorting the search results, and setting case-sensitive on will speed things up a little. Also searching for eq instead of wo will speed things up if you know the exact text of a field. Same for bw if you know the beginning letters of the field text you're searching. Searching for dates slows down a little because of the date conversions necessary for comparison.And finally, a 604e (or DEC Alpha) helps a lot.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== 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:
>I do, however, have some questions about RAM & cache settings for >WebStar and WebCatalog. What settings are the most important for >speed? The actual inventory file is 20 Megs. There're other database >files such as details, options, etc. Make sure there is enough RAM allocated such that WebCatalog never has to unload 1 database to load another. Use About This Computer from the Finder to watch how much RAM is being used, and perform a search on a big database. Watch the RAM bar go up, then do a search on your other databases (if any) and if the RAM bar goes *down* then you it has unload the first database to get the second into RAM. Give it more RAM if this happens.Turn on Template Caching in your preferences to reduce disk hits. Tab-delimited databases import a little bit faster than Merge format.>Also, are there ways of writing the search string to improve performance >(ie put the most limiting field for the search first to drastically >reduce records being compared for subsequent field criteria)?
[lookup] is a special-case search that is the fastest, because it does an exact match (case-sensitive) on one field only. Use it for finding a particular SKU or password or things like that.For general searching, setting rank=off will cause it to not spend time sorting the search results, and setting case-sensitive on will speed things up a little. Also searching for eq instead of wo will speed things up if you know the exact text of a field. Same for bw if you know the beginning letters of the field text you're searching. Searching for dates slows down a little because of the date conversions necessary for comparison.And finally, a 604e (or DEC Alpha) helps a lot.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== 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/
Grant Hulbert
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:
emailer w/F2 (1997)
system crashes, event log (1997)
Here is the code: (2000)
Is [thisurl] http or https? (1998)
converchars in sendmail context.... (2004)
price totals (2003)
Windows XP and cookies (2004)
Reversed words (1997)
Other then credit cards-how? (1997)
sorting question... (2001)
WebMerchant Error (1998)
[WebDNA] Processor Maxing out (2010)
[quantity] solved (1997)
rotating thumbnails (1997)
Do not truncate a whole word (2004)
Protect (1997)
Nesting format tags (1997)
NT considerations (1997)
Configuring E-mail (1997)
Dates! (1998)