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:
[OT] Hacked IIS/FTP (2002)
Showif with an or (2003)
Running 2 two WebCatalog.acgi's (1996)
W* 3.x & WebCat + WebMerchant (1998)
webcat 2.1 new cart fields - please explain more (1998)
Re:FYI: Error message (1996)
emailer w/F2 (1997)
Multiple download orders of the same product? (1997)
WC Database Format (1997)
(2002)
Not really WebCat- (1997)
[redirect] w/o showing args? (1999)
WebDNA 5.1 is now available! (2003)
[taxrate] question (1997)
5.0 Pricing (2003)
two unique banners on one page (1997)
How to verify email address (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Opinion: [input] should be called [output] ... (1997)
Setting up shop (1997)