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:
>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:
TCPConnect , can I get an example, pretty please. (2002)
Cancel Subscription (1996)
[SearchString] usage (1997)
Using WC for Bulk Emailings (1997)
[WebDNA] Sorting questions (2009)
[ShowIf] if the varieable exists (1998)
[listfiles] problems (1997)
Web*3 virtual hosting Webcatalog problem (1998)
New user...how do I create URLs from form fields? (2000)
Image upload (2000)
numfound question (2005)
creator code (1997)
Stopping a [Loop] in mid-stream ... (1997)
SQL 2000 Project (2002)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Separate SSL Server (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
How to implement 'email to a friend' feature? (2002)
Multiple prices (1997)
select multiple (1997)