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:
International Orders (1998)
Can I invoke an ssi plugin from within a webcat page (1997)
Prevent multiple appends with Reload Button (1997)
Carts & Refering URLs (1997)
WebMerchant/MacAuthorize (1998)
WebDNA Threaded Discussions? (2004)
Freeze (2003)
Multiple prices (1997)
problem serving foreign languages text (1997)
Order Date (2003)
Duplicate Cart #'s (1998)
Mozilla/4. and Browser Info.txt (1997)
RE: Can a database get stomped by simultaneous access? (1997)
Document Contains No Data! (1997)
WCS Newbie question (1997)
How To question on setting up downloads (1997)
Getting Total Quantity (1997)
REPOST: How do _you_ back up your db? (2000)
WC Database Format (1997)
Suggestions (1998)