Re: Help with database strategy

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18064
interpreted = N
texte = >>Doesn't WebCat have a 100 field limit? > >No it does not. You can have as many fields as you want. Having 400 fields in a database of only 200 records is very inefficient way to do it, but I doubt you'll see much difference either way since WebCat's so fast already ...By the way, all I really mean by *inefficient* is that most databases perform faster with a large number of records and a smaller number of fields. Your situation will produce the opposite condition, but it's nothing to worry about ... especially with such a small database to begin with. So I think you should just do it in whatever way seems the easiest for you.On the other hand, if you're planning to scale up to hundreds of thousands of records, that would give you a good reason to spend more time creating a more complicated but possible more efficient system of interrelated db's ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: Help with database strategy (Larry Hewitt 1998)
  2. Re: Help with database strategy (Marty Schmid 1998)
  3. Re: Help with database strategy (PCS Technical Support 1998)
  4. Re: Help with database strategy (Kenneth Grome 1998)
  5. Re: Help with database strategy (Kenneth Grome 1998)
  6. Re: Help with database strategy (Matthew Steele 1998)
  7. Help with database strategy (Marty Schmid 1998)
>>Doesn't WebCat have a 100 field limit? > >No it does not. You can have as many fields as you want. Having 400 fields in a database of only 200 records is very inefficient way to do it, but I doubt you'll see much difference either way since WebCat's so fast already ...By the way, all I really mean by *inefficient* is that most databases perform faster with a large number of records and a smaller number of fields. Your situation will produce the opposite condition, but it's nothing to worry about ... especially with such a small database to begin with. So I think you should just do it in whatever way seems the easiest for you.On the other hand, if you're planning to scale up to hundreds of thousands of records, that would give you a good reason to spend more time creating a more complicated but possible more efficient system of interrelated db's ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://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:

checksum for credit cards? (1997) Format question WC Mac f3 (1997) Cache Access Error (2000) Subtotal Not Calculated on Invoice.html (1998) How To question on setting up downloads (1997) Problems with [Applescript] (1997) Developers in Washington State (2004) Help! WebCat2 bug (1997) wired [protect] action? (1998) RE: too many nested [xxx] (1997) Database monitoring (2005) [WriteFile] problems (1997) Shopping Cart Problem (1998) WebCatalog2 Feature Feedback (1996) [ShowNext] (1997) Help!!!! (1999) WebCat2 - many [carts] on one template page? (1997) Expiration of Carts (1997) Summary search -- speed (1997) nesting limits? (1998)