[WebDNA] Which is more efficient? New db or add to existing db

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110474
interpreted = N
texte = --047d7b621a5ea3299404e012b54f Content-Type: text/plain; charset=ISO-8859-1 We're working on a new project that will require one of two options: 1) add a new field to one of our existing DBs (the db is one of our larger ones, too) 2) Make a new db that contains a primary key and the desired new field Which would be the most efficient or is there any difference in terms of performance? -- Alex Agnew IT/Web Developer - KnifeCenter.com alex@knifecenters.com --047d7b621a5ea3299404e012b54f Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
We're working on a new project that will require one o= f two options:
1) add a new field to one of our existing DBs (the db is= one of our larger ones, too)
2) Make a new db that contains a pr= imary key and the desired new field

Which would be the most efficient or is there any diffe= rence in terms of performance?

--
= Alex Agnew
IT/Web Developer - KnifeCenter.com
alex@knifecenters.com
--047d7b621a5ea3299404e012b54f-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Which is more efficient? New db or add to existing db (John Butler 2013)
  2. [WebDNA] Which is more efficient? New db or add to existing db (Alex Agnew 2013)
--047d7b621a5ea3299404e012b54f Content-Type: text/plain; charset=ISO-8859-1 We're working on a new project that will require one of two options: 1) add a new field to one of our existing DBs (the db is one of our larger ones, too) 2) Make a new db that contains a primary key and the desired new field Which would be the most efficient or is there any difference in terms of performance? -- Alex Agnew IT/Web Developer - KnifeCenter.com alex@knifecenters.com --047d7b621a5ea3299404e012b54f Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
We're working on a new project that will require one o= f two options:
1) add a new field to one of our existing DBs (the db is= one of our larger ones, too)
2) Make a new db that contains a pr= imary key and the desired new field

Which would be the most efficient or is there any diffe= rence in terms of performance?

--
= Alex Agnew
IT/Web Developer - KnifeCenter.com
alex@knifecenters.com
--047d7b621a5ea3299404e012b54f-- Alex Agnew

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:

All questions are welcome on this list (1997) Multiple Search Fields (1998) Setting up the server (1997) RE: Credit Card not accepted (1998) URGENT: NO BUG, woFIELDdata & FIELDword=ww (2002) writefile - continued (1997) More on the email templates (1997) WebCatalog not running after upgrade (2000) Emailer.Out (1998) Country & Ship-to address & other fields ? (1997) PCS Frames (1997) Weird error/limit - something amiss? (1997) WebCatalog can't find database (1997) [WebDNA] Add to Cart,/ show cart: unable to access page (2016) Re:Searching for ALL / empty form field (1997) Removing [showif] makes a big difference in speed (1997) dos performance (1998) member pages (2000) Re-Shipping using Book/Ship Method (2004) Set Line Item (1999)