Hi All Members,

Have joined this group just now....

Pl help in deciding what is the right approach......

Is it better to have more tables with less records or less tables with more records?

the latter

I think that the answer depends on the specific problem, so either one might be right for a given situation. In most cases, I would agree with r937 that fewer tables with more rows are generally better.

-PatP

Thanks a lot.
I had the same feeling.

This raise other question, request you to calrify

In my plan of implementation will be using MySql. One table will grow upto 1 million records per year and this table will updated and queried heavily, how will the performance be affected? On a average there might be about 350 update threads and about 300 query threads happening almost at the same time.

performance depends on existence of proper indexes on the table, and also on server tuning

Since I have good number of updates happening, Indexes will affect the performance. Pl advice?

They will improve the performance of your update if the index covers your WHERE condition

I thank all the members for sharing the knowledge.

Request is there any other feature which can be used in MySql to improve performance apart from server and optimizer tuning, pl let me know.