Re: HUGE DATABASES
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20065
interpreted = N
texte = I have setup web catalog with a catalog of 70,000 items (7MB) on my Windows NT server with PII-266MHz and 128MB RAM. Everything works great with that. Now I am tryingto add a ItemNotes database to the same store that contains technical information about the 70,000 items. The ItemNotes database has over 1 MILLION records (85MB) andhas drastically effected the performance of the entire site. All thought it works, it may take up to 3 minutes to display the ItemNote.tpl when pulling informationoff the large database.My question: Is another 128MB going to help, and if so how much??? Or are there other ways to improve proformance with database of this size???Thanks,Mark Bergkvist
Associated Messages, from the most recent to the oldest:
I have setup web catalog with a catalog of 70,000 items (7MB) on my Windows NT server with PII-266MHz and 128MB RAM. Everything works great with that. Now I am tryingto add a ItemNotes database to the same store that contains technical information about the 70,000 items. The ItemNotes database has over 1 MILLION records (85MB) andhas drastically effected the performance of the entire site. All thought it works, it may take up to 3 minutes to display the ItemNote.tpl when pulling informationoff the large database.My question: Is another 128MB going to help, and if so how much??? Or are there other ways to improve proformance with database of this size???Thanks,Mark Bergkvist
Mark Bergkvist
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:
Change to 5.0 per website licensing (2003)
Migrating to NT -Reply (1997)
[WriteFile] problems (1997)
Writefile (2000)
WebDNA Intranet Edition release (2002)
db protection on NT (1997)
WebCatalog Hosting (1996)
Calendar Solutions (1998)
Hiding HTML and page breaks (1997)
[WebDNA] shopping sites and the "old commerce tags" (2012)
[WebDNA] site becomes unavailable and WebCatalog warnings (2017)
Couple of questions (1999)
form image (2000)
EMERGENCY: WebCatalog stopped processing .HTML (IIS) (2003)
WCS Newbie question (1997)
Trouble with formula.db (1997)
JavaScript (1998)
WebCat2 Append problem (B14Macacgi) (1997)
[WebDNA] unix-Linux Intel Apache Module version 8.0.2 (2016)
[WebDNA] Bug? [fileinfo..] You decide (2016)