Re: Big Databases

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11526
interpreted = N
texte = >Can I get some guidance on the practical limits for WebCat handling large >databases? I have a client who wants to do a CustomerID lookup from about a >100,000 record Customer database and if a match is found to return the >customer info (name address etc) to the order entry form. > >If their marketing trial is successful they'd like to scale up the site and >put up a Customer database that is in excess of 2 million records. I don't >have any experience in dealing with databases with this number of records >so I'm flying blind - I don't even have a feel for how large in Mbytes >these databases will be. Could I get some input from the other users on the >sizes (in records and Mbytes) and performances of their WebCat databases? >Thanks as always -martySearches in my 16000 record database never take more than one second - and usually way less than that.The size of the database doesn't depend on how many records it has - it depends on the number of characters stored inside. It's impossible to say how much RAM it will take without knowing how big the average record is.Do you have any idea how much information will be stored in each record - on average>Sincerely, Ken Grome ..... ken@iav.com http://usarea.net/home.html Associated Messages, from the most recent to the oldest:

    
  1. Re: Big Databases (Marty Schmid 1997)
  2. Re: Big Databases (Grant Hulbert 1997)
  3. Re: Big Databases (Kenneth Grome 1997)
  4. Big Databases (Marty Schmid 1997)
>Can I get some guidance on the practical limits for WebCat handling large >databases? I have a client who wants to do a CustomerID lookup from about a >100,000 record Customer database and if a match is found to return the >customer info (name address etc) to the order entry form. > >If their marketing trial is successful they'd like to scale up the site and >put up a Customer database that is in excess of 2 million records. I don't >have any experience in dealing with databases with this number of records >so I'm flying blind - I don't even have a feel for how large in Mbytes >these databases will be. Could I get some input from the other users on the >sizes (in records and Mbytes) and performances of their WebCat databases? >Thanks as always -martySearches in my 16000 record database never take more than one second - and usually way less than that.The size of the database doesn't depend on how many records it has - it depends on the number of characters stored inside. It's impossible to say how much RAM it will take without knowing how big the average record is.Do you have any idea how much information will be stored in each record - on average>Sincerely, Ken Grome ..... ken@iav.com http://usarea.net/home.html Kenneth Grome

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:

quantity minimum problem (1997) Serving images from databases (1998) Large databases in WebCat (1997) Arbitrary limits on length of data in cart header fields? (2000) URGENT: BUG, woFIELDdata & FIELDword=ww (2002) NT version (1997) WebDNA and FTP (2003) Country & Ship-to address & other fields ? (1997) Maybe off topic but how to charge (1997) SQL on Linux - Howto? (2000) Webcat/Webmerchant (1998) using showpage and showcart commands (1996) [OT] Form Check java problem (2003) Talk list archives down? (2003) MacOS X Server problems (2001) searching multiple databases in single search (1997) Looking for a Manual (1997) [WebDNA] sagepayments TLS? requests now failing (2018) Thanks... (1999) New [If] command question + New Feature Request (2000)