Krishna Chandra Prajapati wrote:
> Hi list,
> I want to insert 10000 records/sec into table. There can be n number of
> tables with unique data in each. What are the possible ways to do ?
The manual is your friend. It doesn't hurt to consult it.
LOAD DATA INFILE ...
And we even have both general and specific suggestions on improving
INSERT performance in our Optimization chapter:
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN