MySQL Forums :: Newbie :: Database effeciency

Advanced Search

Database effeciency
Posted by: Mac zac ()
Date: November 04, 2009 02:25AM

hi guys

I'm new to mysql i have a table called table101 that has certain fields that need to updated frequently at the same time its accessed by other applications also. I would like to know if it is more effecienct to create a intermediatary table like a temperory storage and once the data does not require anymore updates then send the data to table101 or is it more effeceint just to do the updates on table101 directly.

Inshort is it better to use a single table to get the job done or does using 2 tables increase the effeciency.


Options: ReplyQuote

Subject Written By Posted
Database effeciency Mac zac 11/04/2009 02:25AM
Re: Database effeciency Rick James 11/05/2009 09:04AM
Re: Database effeciency Mac zac 11/06/2009 02:40AM
Re: Database effeciency Vadim Kiryukhin 11/06/2009 05:45AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.