Hi,

> 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)..now should i make my transaction table for
> each month..which means there will be 12 tables..or is there any other

Take one table - just as a example - I have 60.000.000 records in my
biggest table - and this is the data from 1/2 a year :-)

> way..i am thinking from performance and management..and reports..
> thks
>

If you are concerend about reports from the last years - the best way is
to store the data in one table, and then aggregate the table on a
monthly base into a different table.

The anual report gets generated from the aggregated data and the
detailed report for the month from the "original" table.

Chris

>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>

___________________________________________________________
Gesendet von Yahoo! Mail - Jetzt mit 1GB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de