Re: [PHP] Re: Can php/mysql handle 10000s of records

2003-09-07 Thread Raditha Dissanayake
Hi, Done something similar on a pentium pro around a million years ago :-) gazillion dollar databases would find it hard to compete with mysql on the speed of select queries. but mysql can't compete on inserts most notably on tables with lot of indexes. If you have to insert thousands of rows in

[PHP] Re: Can php/mysql handle 10000s of records

2003-09-07 Thread Nabil
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 desk