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:

New user...how do I create URLs from form fields? (2000) Field name-subcategory (1997) Almost a there but..bye bye NetCloak (1997) math on date? (1997) Not really WebCat (1997) Paranoid about serial numbers...not (1998) Open Databases on Restart (1999) Mass download. (2003) Webstar 1.3.1 PPC (1997) Security Issues and WebCommerce Solution (1997) Limiting user access to .tmpl files (1997) 1 cent answer? (1998) URL problem (2007) [showif] and equality (1998) Share Bulletin Board? (1998) fieldType=num (1997) RE:It just Does't add up!!! (1997) Search Engines (2000) [ShowIf] and empty fields (1997) RE: Error: template (1997)