Re: HUGE DATABASES

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 20067
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??? Or are >there other ways to improve proformance with database of this size??? > >Thanks, >Mark Bergkvist > > webcat swaps databases in and out of RAM as needed when RAM is limited. Definitely increase your RAM. You are probably slowed down by loading and unloading that huge database.Good luck!Sandy Associated Messages, from the most recent to the oldest:

    
  1. Re: Huge databases and RAM (PCS Technical Support 1998)
  2. Re: Huge databases and RAM (Bob Minor 1998)
  3. Re: Huge databases and RAM (PCS Technical Support 1998)
  4. Re: Huge databases and RAM (PCS Technical Support 1998)
  5. Re: Huge databases and RAM (The Mooseman 1998)
  6. Re: Huge databases and RAM (Martin Gertz Bech 1998)
  7. Re: Huge databases and RAM (Kenneth Grome 1998)
  8. Huge databases and RAM (Martin Gertz Bech 1998)
  9. Re: HUGE DATABASES (Sandra L. Pitner 1998)
  10. Re: HUGE DATABASES (Kenneth Grome 1998)
  11. Re: HUGE DATABASES (Mark Bergkvist 1998)
>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??? Or are >there other ways to improve proformance with database of this size??? > >Thanks, >Mark Bergkvist > > webcat swaps databases in and out of RAM as needed when RAM is limited. Definitely increase your RAM. You are probably slowed down by loading and unloading that huge database.Good luck!Sandy Sandra L. Pitner

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:

FoxPro & WebDNA (2006) no global [username] or [password] displayed ... (1997) Lots of bounce errors (2007) Ram usage (1999) WebCat2.0 [format thousands .0f] no go (1997) Too many lines too add in one go (2003) A little syntax help (1997) WebCatalog2 Feature Feedback (1996) failure to encrypt (or maybe decrypt) (1999) WC2b15 File Corruption (1997) 2 easy questions re: [showif] and [sendmail] (1997) Header info in content (1998) Permissions Ignored - PLEASE HELP (2003) Setting up shop (1997) Using Cookie for client specific info? (1997) chat opinion ... (2002) pop up menu's (1998) MacWorld NY (2000) Help name our technology! (1997) SKU (1997)