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:

Where's Cart Created ? (1997) Denying access by IP address (2000) Cart# (1997) HELP WITH DATES (1997) Removing [showif] makes a big difference in speed (1997) users.db (1999) strange problem listfiles and movefile (long) (2000) Search in 2 or more catalogs (1997) WebCat Error Log problem (2.0.1, acgi, Mac) (1997) Emailer and encryption (1997) Ports? (2002) supressing math results (1997) Make sure I understand this??? (1997) Where's 3.0 Online Docs? (1999) RE: protect tag not working (1998) Edit Plus and webcat code library - Gary Krockover (2003) [WebDNA] variable name limit - clarification (2009) WC2.0 Memory Requirements (1997) database problem (2003) Separate SSL Server (1997)