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:

suffix mapping for NT? (1997) Emailer file formats (1998) Live hits (2003) MacAuthorize and WebMerchant (1997) WebCat2 - storing unformatted date data? (1997) Running _every_ page through WebCat-error.html (1997) [shownext] support - MacOS (1997) Setting up shop (1997) Log-in Scheme (2003) RE: Formulas.db + Users.db (1997) The List is Changing (1997) Email within tmpl ? (1997) Items XX to XX shown (1997) RAM variables (1997) WebCat2 - Getting to the browser's username/password data (1997) MS Access (1999) Am I going senile? (Price recalc based on quantity) (1997) WebCatalog Mac 2.1b3 (1997) Public beta 2 for WebCatalog 4.0 is now available. (2000) Searching an Email database (1997)