re: Large databases in WebCat
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14560
interpreted = N
texte = >When, if ever, would you recomend that a customer go with a SQL DB vs. >Web Catalog?For today, at least:If the web server *must* be unix instead of Windows or Mac. If you have more database than memory (millions of records), although hybrids are still quite viable (WebCatalog for the store, SQL for the millions of customer records). If your MIS department requires that the backice SQL server be kept up-to-date (e.g. inventory levels) on a second-to-second basis, although even SQL can't handle record-locking in a stateless web environment.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:
>When, if ever, would you recomend that a customer go with a SQL DB vs. >Web Catalog?For today, at least:If the web server *must* be unix instead of Windows or Mac. If you have more database than memory (millions of records), although hybrids are still quite viable (WebCatalog for the store, SQL for the millions of customer records). If your MIS department requires that the backice SQL server be kept up-to-date (e.g. inventory levels) on a second-to-second basis, although even SQL can't handle record-locking in a stateless web environment.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:
Multiple 'Users.db' files not possible (1997)
creator code (1997)
Hyperboard users wanting a quoted message (1998)
Max Record length restated as maybe bug (1997)
Interface to Quickbooks (2005)
could someone please try this - it's very quick and easy (2000)
Bug or syntax error on my part? (1997)
[SHOWIF] (1997)
writing db to disk (1997)
[OT] 'Email this story to a friend' (2003)
Date search - yes or no (1997)
Applescript in Webcatalog problem (1997)
WebCatalog [FoundItems] Problem - LONG - (1997)
Forms & Tables (1998)
Multiple prices (1997)
Re:Virtual hosting and webcatNT (1997)
THANKS!!! ShipCosts.db and debugging (1997)
Configuring E-mail (1997)
WebCat2 - storing unformatted date data? (1997)
Multiple fields on 1 input (1997)