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:

WebCat2b13MacPlugIn - [showif][search][/showif] (1997) WebDNA Solutions ... sorry! (1997) [protect] on NT? (1997) How To question on setting up downloads (1997) Need help... (1997) WebCat2 beta 11 - new prefs ... (1997) Protect usage (1999) [OT] (waaaay OT) further off topic than before (2004) Upgrading from version (1998) Need something like [listchars] ... (2000) [OT] Bit of New Zealand Fun (2004) Dates - Search and Sorting (1999) Security Question (1997) WebDNA 6 (2004) Strange intermittent WebDNA problems (2008) Sending mail (was forms and variables) (1998) RE: protect tag on NT (1997) Join us at MacWorld! - Part 2 (1998) Need WebDNA that crashes server for testing (2000) Re:multiple digests, please stop (1997)