Adam, Mysql will easily handle this. This certainly doesn't constitute a large database.
Correctly indexing the database should see you doing speedy queries on years worth of data. Sounds like you've used access in the past :-) Andy > -----Original Message----- > From: Adam Gerson [mailto:[EMAIL PROTECTED] > Sent: 09 July 2003 14:47 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Can mysql handle this load? > > > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
