It can handle 1,000,000 records without breaking a sweat.
On Wed, 2003-07-09 at 09:54, Adam Gerson wrote: > From: Adam Gerson <[EMAIL PROTECTED]> > Date: Wed Jul 9, 2003 9:48:20 AM America/New_York > To: [EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] > www.cgps.org -- Adam Voigt ([EMAIL PROTECTED]) Linux/Unix Network Administrator The Cryptocomm Group -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
