Re: Large Database Options?

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 22453
interpreted = N
texte = At 7:46 PM -0000 1/11/99, Juliana Sun wrote: >I have a database with 2.5 million records (101 MB) storing a product SKU# >with a detailed description of the product. When searching for the SKU#, >the NT server crashes because of the database size. Can anyone recommend >another solution in addition to adding more RAM? Is there any particular reason that you don't want to add more memory to your server? Given the price of RAM these days, it's probably cheaper to buy more memory than to spend the time required to implement any of the other solutions that you mentioned...-Daveo--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+ Associated Messages, from the most recent to the oldest:

    
  1. re: Large Database Options? (PCS Technical Support 1999)
  2. Re: Large Database Options? (Bob Minor 1999)
  3. re: Large Database Options? (Juliana Sun 1999)
  4. Re: Large Database Options? (Kenneth Grome 1999)
  5. Large Database Options? (Juliana Sun 1999)
  6. Re: Large Database Options? (Dave MacLeay 1999)
At 7:46 PM -0000 1/11/99, Juliana Sun wrote: >I have a database with 2.5 million records (101 MB) storing a product SKU# >with a detailed description of the product. When searching for the SKU#, >the NT server crashes because of the database size. Can anyone recommend >another solution in addition to adding more RAM? Is there any particular reason that you don't want to add more memory to your server? Given the price of RAM these days, it's probably cheaper to buy more memory than to spend the time required to implement any of the other solutions that you mentioned...-Daveo--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+ Dave MacLeay

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:

[WebDNA] calling a webDNA tmpl from PHP? (2008) Problems passing [SKU] with $Replace in 2.0 (1997) Securing/hiding database file (2000) Showif for mulitple variations (1997) Template Cache problem (2000) [searchString] (1997) Re[4]: Charting records by state (2000) 2cd pare of eyes. (2001) First time Installation problems (1999) Stopping bad HTML propagation ? (1997) [feature req?]DeleteFounditem (2002) WebCat b15 Mac plug-in (1997) Languages (1997) Emailer setup (1997) WC2b12: Yes, Formulas.db is for real (1997) protect tag on NT IIS (1997) unable to launch acgi in WebCat (1997) Problem: 3.0 doesn't update carts (1997) PCS Frames (1997) Emailer file formats (1998)