women_lover_best wrote:

> We are developing a POS application..on average there will be 50-60
> terminals connecting to server..and there will be many transactions in
> day(guess 1 to 2 lakh)

lakh?

> ..now should i make my transaction table for
> each month..which means there will be 12 tables..or is there any other
> way..i am thinking from performance and management..and reports..

You can keep everything together in a single table. Just create proper
indices, and check PLAN for each query that runs the reports. The
performance difference for 12 times more data should not even be
noticable when proper index is used.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org