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:

WebCat2b12 CGI Mac - [shownext] problem (1997) Uploading a new database (2001) [showif] problem (1999) sort problems....bug or brain fart? (1997) [WebDNA] o search engines index .db files? (2009) Bug Report, maybe (1997) OK, here goes... (1997) Trouble with formula.db (1997) & not allowed in db by definition? (1999) Re:2nd WebCatalog2 Feature Request (1996) Text data with spaces in them... (1997) quotes and truncating? (1997) Searchtitle (2000) [Announce]: Web server security and password protection (1997) Generating unique SKU from [cart] - FIXED! (1997) Where is Orders.db appended? (2000) japanese characters (1997) Remove me from your list immeadiately (1998) HELP WITH DATES (1997) protect tag on NT IIS (1997)