Re: Which approach is better?
Posted by: weitat chok
Date: November 16, 2006 09:34PM

hi bob, I had go through that mysql quite weak in joining tables.

So, would it be better to store all those setting in to 1 campaign table?

camp_id | camp_name | ... |SetA | SetB | SetC | ...

I don't mind to change the db structure, as long as the system main concern is fast fetching, and use least processing power due to the high traffic and demand of DB requested.

And i wonder will the SELECT statement slow down if i put all those setting in one table instead of joining the campaign table with those setting table

Thanks

Options: ReplyQuote


Subject
Written By
Posted
November 07, 2006 02:55AM
November 08, 2006 06:19PM
November 09, 2006 08:59PM
November 09, 2006 09:17PM
November 09, 2006 10:52PM
Re: Which approach is better?
November 16, 2006 09:34PM
November 16, 2006 09:51PM
November 16, 2006 10:14PM
November 17, 2006 12:18AM
November 19, 2006 09:33PM


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.