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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
