Re: HUGE DATABASES
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20066
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 trying>to 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) and>has 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 information>off the large database.>>My question: Is another 128MB going to help, and if so how much???Yes, especially if WebCat is moving your db's into and out of RAM because there's not enough available to keep them both in RAM.>Or are there other ways to improve proformance with database of this size???There are probably ways to configure your searches so they display results faster than 3 minutes, depending on what you're searching for or how you actually need to perform those searches.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
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 trying>to 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) and>has 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 information>off the large database.>>My question: Is another 128MB going to help, and if so how much???Yes, especially if WebCat is moving your db's into and out of RAM because there's not enough available to keep them both in RAM.>Or are there other ways to improve proformance with database of this size???There are probably ways to configure your searches so they display results faster than 3 minutes, depending on what you're searching for or how you actually need to perform those searches.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Kenneth Grome
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:
cart (1997)
RE: [WebDNA] V8.6 FCGI (2018)
[WebDNA] Daily tasks without triggers (2011)
Sorting by date (1997)
Making a page expire with web catalog? (1999)
Max Record length restated as maybe bug (1997)
Version 2.0 and 1.6 simultaneous (1997)
Autonumber in Table (2006)
RE: [WebDNA] db admin tool (2008)
DB Field Name? (2000)
Showing once on a founditems (1997)
Sorting nested search (2003)
Suffix or Line? (1999)
[input] [/input] (1997)
still facing truncated [texta] problem (2000)
Show if not working in version 4 (2002)
.tmp files (2000)
WebCat2: Found Items syntax, etc. (1997)
triggers (2002)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)