Can php/mysql handle 10000s of records

From: Adam Gerson <agerson@cgps.org> Date: Wed Jul 9, 2003 9:48:20 AM America/New_York To: php-general@lists.php.net Subject: Can php/mysql handle 1000's of records? I know this questions is a little of topic, but I figured the members of this list would have experience in this area. I am writing an attendance system in php/mysql 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 agerson@cgps.org www.cgps.org