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:

Re:Multiple SSL Keys (1998) Hiding HTML and page breaks (1997) WCS Newbie question (1997) Silly Question (2003) 2.0 Info (1997) OT: Just for a waste of time (2003) How To question on setting up downloads (1997) wc 2 pro users - sites, quotes wanted (1997) Why are some admin pages not encrypted? (2000) Confirmation emails classified as junk (2000) Ship via options price (2000) [username][password] not showing up. (2000) Why did this copyfile stop working? (2004) Still having problems with Authen (1997) Re:FYI: Error message (1996) about this server and links to who (1997) Nested tags count question (1997) error No such file (2001) send mail problem? (1997) [searchString] (1997)