Re: Is there a max number of fields?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19221
interpreted = N
texte = Think twice before subdividing your inventory database. Many of the shopping cart functions depend on looking up things based on the SKUs in the specified database. If they can pick products from multiple categories, this would complicate things immensely if you had to figure out where to get at the data again for lookups, etc. (for invoice pages) If you could fit all necessary info. in the cart at the beginning (using textA,B, etc.) fields, maybe this wouldn't be as much an issue.There's nothing wrong with having a category and several subcategory fields for an item. Specifying those fields as well will actually speed up your searches. Items can even belong to several subcategories if you learn search delimeters such as , between items to pick apart multi-word subcategories.On the other hand, if you have many SKUs which share information, then it would make sense to split the shared information into a related database to avoid repetition in the database.Good luck!Sandy >At 04:10 PM 7/30/98, you wrote: >>>>>I wanted to ask you guys if there is any limit on the number of fields in >>>>>a database? >>>> >>>>No. >>> >>>Okay, on a somewhat related note then, how do you know when to create one >>>database with many fields OR several databases with a few fields each. >> >>That is a very good question too. I might end up dividing the DB into >>several smaller ones, specially since in this DB, ALL searches will be >>performed on a unique SKU value... > >So you think the best way to go would be to create 25 separate catagory >databases??? >If yes, how would I do a search by brand since some of the brands have >products in many catagories? > > > >Angel J. Bennett ! We want the world and >VP / Creative Dir. ! we want it... >The WWW Store ! NOW! >818-905-6787 ! http://www.thewwwstore.com > Associated Messages, from the most recent to the oldest:

    
  1. Re: Is there a max number of fields? (Charles Kefauver 1998)
  2. Re: Is there a max number of fields? (Sandra L. Pitner 1998)
  3. Re: Is there a max number of fields? (Charles Kefauver 1998)
  4. Re: Is there a max number of fields? (Sandra L. Pitner 1998)
  5. Re: Is there a max number of fields? (Angel Bennett 1998)
  6. Re: Is there a max number of fields? (Charles Kefauver 1998)
  7. Re: Is there a max number of fields? (Sandra L. Pitner 1998)
  8. Re: Is there a max number of fields? (Charles Kefauver 1998)
  9. Re: Is there a max number of fields? (Charles Kefauver 1998)
  10. Re: Is there a max number of fields? (Angel Bennett 1998)
  11. Re: Is there a max number of fields? (Kenneth Grome 1998)
  12. Re: Is there a max number of fields? (PCS Technical Support 1998)
  13. Is there a max number of fields? (Charles Kefauver 1998)
Think twice before subdividing your inventory database. Many of the shopping cart functions depend on looking up things based on the SKUs in the specified database. If they can pick products from multiple categories, this would complicate things immensely if you had to figure out where to get at the data again for lookups, etc. (for invoice pages) If you could fit all necessary info. in the cart at the beginning (using textA,B, etc.) fields, maybe this wouldn't be as much an issue.There's nothing wrong with having a category and several subcategory fields for an item. Specifying those fields as well will actually speed up your searches. Items can even belong to several subcategories if you learn search delimeters such as , between items to pick apart multi-word subcategories.On the other hand, if you have many SKUs which share information, then it would make sense to split the shared information into a related database to avoid repetition in the database.Good luck!Sandy >At 04:10 PM 7/30/98, you wrote: >>>>>I wanted to ask you guys if there is any limit on the number of fields in >>>>>a database? >>>> >>>>No. >>> >>>Okay, on a somewhat related note then, how do you know when to create one >>>database with many fields OR several databases with a few fields each. >> >>That is a very good question too. I might end up dividing the DB into >>several smaller ones, specially since in this DB, ALL searches will be >>performed on a unique SKU value... > >So you think the best way to go would be to create 25 separate catagory >databases??? >If yes, how would I do a search by brand since some of the brands have >products in many catagories? > > > >Angel J. Bennett ! We want the world and >VP / Creative Dir. ! we want it... >The WWW Store ! NOW! >818-905-6787 ! http://www.thewwwstore.com > Sandra L. Pitner

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:

Stumped by [thisUrl] (2006) Bad Cookie (1998) WebCat2b13MacPlugIn - syntax to convert date (1997) append problem on RH linux - code listing (2002) Generating Report Totals (1997) [shownext max=?] armed (1997) Grep help, please ... (2003) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) Emailer & IMail List Server (1998) Weird error/limit - something amiss? (1997) Press Release hit the NewsWire!!! (1997) how to check for no value while using [URL] to prevent cr (1999) Blocking off access (2005) problems with 2 tags shakur (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) SKU lookup (1997) problems with 2 tags (1997) Summary search -- speed (1997) Webstar 1.3.1 PPC (1997) Further tests with the infamous shipCost (1997)