Re: Big Databases

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11528
interpreted = N
texte = >The size of the database doesn't depend on how many records it has - it...>Do you have any idea how much information will be stored in each record - >on average>I'm awaiting their IS Dept. to get me some sample records - but they're extremely slow (which is why I'm getting the development project...) so I don't really know yet. Regardless of what is in the records now we're going to strip them down to the bare essentials for our purposes which is: CustomerID, Name, Company, Address, Phone, FAX, E-mail - just the basic contact info.A sample I created used a maximum of about 300 characters (including delimiters) per record. Am I doing the math correct that 100,000 300-character records would require 30 MBytes of RAM? If so then doing a Lookup through 2 million records would not be possible... forgive me if I'm overlooking the obvious. -marty 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)
>The size of the database doesn't depend on how many records it has - it...>Do you have any idea how much information will be stored in each record - >on average>I'm awaiting their IS Dept. to get me some sample records - but they're extremely slow (which is why I'm getting the development project...) so I don't really know yet. Regardless of what is in the records now we're going to strip them down to the bare essentials for our purposes which is: CustomerID, Name, Company, Address, Phone, FAX, E-mail - just the basic contact info.A sample I created used a maximum of about 300 characters (including delimiters) per record. Am I doing the math correct that 100,000 300-character records would require 30 MBytes of RAM? If so then doing a Lookup through 2 million records would not be possible... forgive me if I'm overlooking the obvious. -marty Marty Schmid

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:

Re2: frames & carts (1997) Multiple prices (1997) NY taxRates.db? (1997) automating txt downloads for conversion to webcat db (2006) Pull down menu for categories (2000) Logging purchases (1997) What is the maximum record length? (1998) Webmerchant (1999) forms and variables (1998) Authenticate and IIS (1997) Database Structure? (1998) [WebDNA] PayPal Integration (2017) WC1.6 to WC2 date formatting (1997) Xserve Recommendations (2003) A Global Variable (1997) b12 cannot limit records returned and more. (1997) Error: this shopping cart has already been submitted and (2006) Bug or syntax error on my part? (1997) Server problem? (1998) Search results templates (1996)