<DIV style="font-family:Arial, sans-serif; font-size:10pt;"><FONT size="2"><SPAN style="font-family: Arial,sans-serif;">Hello, i am Guillermo Arias, from Peru. I have a doubt about capacity of tables.<BR>I am developing a software for accountants, and my principal problem is about the table for the vouchers. I have to decide to make a table for each year or only one table for all the years. <BR><BR>This table has 11 fields: varchar(10) and 2 fields: numeric (12,2) and is intended to have 900,000 records per year x 13 years = 11'700,000 records<BR><BR></SPAN></FONT><FONT size="2"><SPAN style="font-family: Arial,sans-serif;">What can you suggest me? i do not want the system to be slow using this table.<BR><BR>thanks<BR>guillermoariast(at)hotmail(dot)com<BR><BR></SPAN></FONT><BR> <BR><HR>Get your FREE, LinuxWaves.com Email Now! --> http://www.LinuxWaves.com<BR>Join Linux Discussions! --> http://Community.LinuxWaves.com</DIV>