Mysql will easily handle this. This certainly doesn't constitute a large
Correctly indexing the database should see you doing speedy queries on years
worth of data.
Sounds like you've used access in the past :-)
> -----Original Message-----
> From: Adam Gerson [mailto:agersonl@stripped]
> Sent: 09 July 2003 14:47
> To: mysql@stripped
> Cc: benchmarks@stripped
> 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?
> Adam Gerson
> Systems Administrator / Computer Teacher
> Columbia Grammar and Prep School
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: