[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:

Migrating to NT (1997) Upgrading old WebCat Database Files (1997) RE: Credit Card Checksum (1997) [WebDNA] Stupid question: setheader (2017) 2nd WebCatalog2 Feature Request (1996) help needed: Non-english characters in WebCatalog (1997) Quit revisited (1997) sorting dates (1999) WebCat2b13MacPlugIn - syntax to convert date (1997) Removing [showif] makes a big difference in speed (1997) Search technique question (1998) WebCat2b12 - nesting [tags] (1997) Error:Too many nested [xxx] contexts (1997) How about this? (1998) ShowIf variables (1997) Is [variable] a Number? (2007) Pithy questions on webcommerce & siteedit (1997) WebCat2b13 Command Reference Doc error (1997) WebCat editing, SiteGuard & SiteEdit (1997) Lookup within a Search (2005)