You can also stack the queries to run multiple rows in one insert
Insert into table values (row1col1, row1col2,'row1col3'),
(row2col1,row2col2,'row2col3'),...(rowNcol1,rowNcol2,'rowNcol3')
Bastien
Sent from my iPod
On May 31, 2009, at 8:18, דניאל דנון
wrote:
I've a file of about 500,000
- Original Message -
From: "flint"
To: "דניאל דנון"
Sent: Sunday, May 31, 2009 9:21 AM
Subject: Re: [PHP] mysql_query takes long time...
have you actually tried running the script against your data?
i'm running MySQL/PHP on an old P3/933Mhz box with onl
I've a file of about 500,000 lines, each line contains a string in variety
of lengths, but no less then 3 characters and usually no more then 120.
average of about 80, and maximum of about 250.
I made a PHP script to fetch the data (using fgets), process it and insert
it to a MySQL database.
3 matches
Mail list logo
