Re: Is there a max number of fields?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19239
interpreted = N
texte = >Therefore the Million Dollar Question is, considering all searches (and >embeded searches) will be made using unique SKUs, what is more efficient: >one huge database, or several smaller ones?check out www.musicianstore.com, which has one huge inventory database of about 100 Megs RAM. It is plenty speedy! It also has other child databases related to inventory database.The main reason to split it up would be if there was frequent modifications of data and flushing to disk. You don't want to flush big data files to disk often on a live server. good luck!Sandy 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)
>Therefore the Million Dollar Question is, considering all searches (and >embeded searches) will be made using unique SKUs, what is more efficient: >one huge database, or several smaller ones?check out www.musicianstore.com, which has one huge inventory database of about 100 Megs RAM. It is plenty speedy! It also has other child databases related to inventory database.The main reason to split it up would be if there was frequent modifications of data and flushing to disk. You don't want to flush big data files to disk often on a live server. good luck!Sandy 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:

PCS Customer submissions ? (1997) Help with sorting search results sorting (1998) Help with nested search (1998) passing cart value (2003) WebDNA equivalent for $REQUEST_URI (2004) ShowNext for method=POST (1997) WebCatalog can't find database (1997) Product display (2000) Credit card processing - UK (1997) PCS Frames (1997) Dealer Locator (2008) ANYONE (1999) Calendar Snippet Problems (1998) [Webcat 2]Next (1997) Cart Transfer from Un-Secure to Secure (2000) Country & Ship-to address & other fields ? (1997) WebCat2 - [format thousands] (1997) PCS Frames (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Limit on nested [ShowIf]'s? (1997)