Re: Can php/mysql handle 10000s of records

I ran a script that dump thousands of records a seconds for over 100 copy.. and I got to a database with over 3,500,000 records and while I am dumping this huge date I ran also stimunasouly a select query that returned over 800, 000 record and it worked like a bullet ( this test was on P4 512M desktop pc) cheers "Adam Gerson" <agersonl@cgps.org> wrote in message news:CBEF42DC-B214-11D7-B8FF-000A95931484@cgps.org... > 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 >