Re: Um. silly question perhaps...but I don't know, so I'm askin'..
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37761
interpreted = N
texte = >I have a fulfillment system I developed with web cat. Can Webcat >handle a DB of 8500 products (including images of those products)? > >- TonyHi Tony,Not silly, really. We dove into this about 9 months ago, but on a slightly larger scale...We're running a database to talk with a remote fulfillment warehouse, and we're using several relational databases pulled together from 2 different sources. Some of these db's have over 100,000 records, and I believe the largest one is about 40MB.The main database contains about 60,000 records, for which the inventory numbers are updated every 2 hours using a perl script because webcat takes FOREVER to do tens of thousands of replaces on a very large database. We're talking seconds vs. hours here, literally.My advice is to use a different server to perform updates to your database if at all possible, and use something other than webcat to generate/modify the file if you need the files in a reasonable amount of time. If your database changes rarely, or not at all, then you should be fine on one box.Read-only access to these databases is decent, although we bog down quite a bit these days. We're going from a G4/500 to a G4/867 on OS9 very shortly for a 100% gain in cpu performance (according to our prelim. testing). When 10.1 hits the streets, it may actually be faster than OS9 under a load (fingers crossed) and become a viable solution for webcatters.http://www.tfaw.com/ is the site I'm talking about here, if you're interested in looking around.Good luck,-Dale -- Dale LaFountain Vice President of Information Technology, WebMaster Dark Horse Comics, Inc. mailto:dalel@darkhorse.com Phone: 503-652-8815 x324 http://www.darkhorse.com/------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I have a fulfillment system I developed with web cat. Can Webcat >handle a DB of 8500 products (including images of those products)? > >- TonyHi Tony,Not silly, really. We dove into this about 9 months ago, but on a slightly larger scale...We're running a database to talk with a remote fulfillment warehouse, and we're using several relational databases pulled together from 2 different sources. Some of these db's have over 100,000 records, and I believe the largest one is about 40MB.The main database contains about 60,000 records, for which the inventory numbers are updated every 2 hours using a perl script because webcat takes FOREVER to do tens of thousands of replaces on a very large database. We're talking seconds vs. hours here, literally.My advice is to use a different server to perform updates to your database if at all possible, and use something other than webcat to generate/modify the file if you need the files in a reasonable amount of time. If your database changes rarely, or not at all, then you should be fine on one box.Read-only access to these databases is decent, although we bog down quite a bit these days. We're going from a G4/500 to a G4/867 on OS9 very shortly for a 100% gain in cpu performance (according to our prelim. testing). When 10.1 hits the streets, it may actually be faster than OS9 under a load (fingers crossed) and become a viable solution for webcatters.http://www.tfaw.com/ is the site I'm talking about here, if you're interested in looking around.Good luck,-Dale -- Dale LaFountain Vice President of Information Technology, WebMaster Dark Horse Comics, Inc. mailto:dalel@darkhorse.com Phone: 503-652-8815 x324 http://www.darkhorse.com/------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Dale LaFountain
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:
access denied problem (1997)
cannot delete last admin (1999)
webcat license???? (1997)
PCS Frames (1997)
price formula (1999)
[WebDNA] writefile (2009)
Site Test Please (2005)
AppleScript question (1997)
Emailer setup (1997)
Cart Already Submitted (2003)
2nd WebCatalog2 Feature Request (1996)
syntax question, not in online refernce (1997)
Error message (1999)
Merging databases (1997)
Letters as SKU (1998)
[MoveFile] (2000)
Round up prices (2000)
MacOS 9 => ODBC=> Ms SQL Server 7 (2000)
Line items in table cells (1997)
ANother SHOWIF problem (1997)