MySQL Forums
Forum List  »  Newbie

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

Written By
Database effeciency
November 04, 2009 02:25AM
November 05, 2009 09:04AM
November 06, 2009 02:40AM
November 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.