Can mysql handle this load?

[Adam Gerson]

I am writing an attendance system in php for my school. We have a 
little less then 1000 students. For every day of the school year one 
record will be entered into a table for each student representing their 
attendance status (present, absent, late, etc...). I also have several 
other supporting tables for relationships. When it comes to reporting 
and querying this DB I am worried that it will very quickly become very 
large and slow. Can mysql handle this? Are there any techniques to 
speed it up? I will trying indexing major columns.

I have also considered keeping all previous days attendance in a 
separate table from the current days attendance and moving things over 
in the middle of the night. This way any operations on the current days 
data will go quickly, but reports on long term things will still be 
slow. Good idea?

Thanks,
Adam




-------------------------------
Adam Gerson
Systems Administrator / Computer Teacher
Columbia Grammar and Prep School
212-749-6200
[EMAIL PROTECTED]
www.cgps.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]