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:
What file? (1997)
Web DNA rates (2000)
is there a [purchase]? (1998)
autocommit problem (1998)
Search 1 Field Twice? (2004)
Deleting Multiple Database Records based on Checkbox (1998)
Just Testing (1997)
RE: Problems with shopping cart (1997)
WCS Newbie question (1997)
linetiems in thankyou.tpl (1997)
unique ascending numbers (2003)
Search Result refinement help (2003)
Re1000002: Setting up shop (1997)
Re:no template caching (1997)
multi-paragraph fields (1997)
[sendmail] and [formvariables] (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Hierarchy of form/text/math variables (renamed thread) (2000)
Resume Catalog ? (1997)
CMSBuilder (2004)