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'reextremely slow (which is why I'm getting the development project...) so Idon't really know yet. Regardless of what is in the records now we're goingto strip them down to the bare essentials for our purposes which is:CustomerID, Name, Company, Address, Phone, FAX, E-mail - just the basiccontact info.A sample I created used a maximum of about 300 characters (includingdelimiters) per record. Am I doing the math correct that 100,000300-character records would require 30 MBytes of RAM? If so then doing aLookup through 2 million records would not be possible... forgive me if I'moverlooking the obvious.-marty
Associated Messages, from the most recent to the oldest:
>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'reextremely slow (which is why I'm getting the development project...) so Idon't really know yet. Regardless of what is in the records now we're goingto strip them down to the bare essentials for our purposes which is:CustomerID, Name, Company, Address, Phone, FAX, E-mail - just the basiccontact info.A sample I created used a maximum of about 300 characters (includingdelimiters) per record. Am I doing the math correct that 100,000300-character records would require 30 MBytes of RAM? If so then doing aLookup through 2 million records would not be possible... forgive me if I'moverlooking 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:
Linux Beta4 Problem (2000)
5.0 Pricing (2003)
Sorting by date (1997)
WebCatalog can't find database (1997)
Ampersand Searching (2000)
File upload in Mac OS X - fixed (2002)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Email Line Breaks (2003)
Help formatting search results w/ table (1997)
Sorting nested search (2003)
[WebDNA] Installing 6.0 onto Server 2008 (2011)
LOG IN LOG OUT (1997)
calculating unique time (1998)
Advice needed. (1998)
You can't buy something twice... (1997)
[WebDNA] WebDNA receiving numerous signal SIGSEGV then crashing (2016)
default value from Lookup (was Grant, please help me) (1997)
PCS Frames (1997)
WebCat2b12 CGI Mac -- Problems propagating the cart through (1997)
Custom formulas.db (1998)