Re: Questions
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17662
interpreted = N
texte = >I have a customer who is considering putting a .db on the net with 4.5>million records on it. (I know I nearly passed out myself!!).>Can web cat handle such a .db. It has approx. 8 fields, & no graphics to>look up.>Also could webcat lookup a .db on a drive as opposed to RAM? I know it>would be slower but it would not require as much RAM.>Any replies appreciated.I'll try something like this:- cutting the file in several pieces (my last test was done with a file of34000 records (15Mb). webcatalog was just perfect)- create an gate file with 4 fields: sku,first,last,filename to tell towebcatalog where to find the searched records. if the searched record isbetween first and last then webcatalog will load the related file andextracts the asked records- create a merge file with all the needed records- this merge file will serve as the final dbIt will be a slow solution, but I think it will not be slower than an sqldatabase solution and you'll save a lot of space. There's no need ofixdexationAnother manner could be to write a script that comminicates with an sqldatabase to retrieve the searched records
Associated Messages, from the most recent to the oldest:
>I have a customer who is considering putting a .db on the net with 4.5>million records on it. (I know I nearly passed out myself!!).>Can web cat handle such a .db. It has approx. 8 fields, & no graphics to>look up.>Also could webcat lookup a .db on a drive as opposed to RAM? I know it>would be slower but it would not require as much RAM.>Any replies appreciated.I'll try something like this:- cutting the file in several pieces (my last test was done with a file of34000 records (15Mb). webcatalog was just perfect)- create an gate file with 4 fields: sku,first,last,filename to tell towebcatalog where to find the searched records. if the searched record isbetween first and last then webcatalog will load the related file andextracts the asked records- create a merge file with all the needed records- this merge file will serve as the final dbIt will be a slow solution, but I think it will not be slower than an sqldatabase solution and you'll save a lot of space. There's no need ofixdexationAnother manner could be to write a script that comminicates with an sqldatabase to retrieve the searched records
helene
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:
os 8.5 (1999)
FormVariable (1999)
Clearly.home (1998)
RAM variables (1997)
A little syntax help (1997)
Training Tapes Improved (1998)
Renumbering/changing sort order of lineitems (2004)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
WebCat2 several catalogs? (1997)
Seeking WebCat Bulletin Board (1999)
Is this google friendly? (2003)
WebCat2 - [format thousands] (1997)
Search for non blank fields (2004)
New public beta available (1997)
How To question on setting up downloads (1997)
[ShowNext] (1997)
problems with 2 tags shakur (1997)
Stopping bad HTML propagation ? (1997)
[WebDNA] [text scope=global] (2014)
2.0 Info (1997)