Posted 08 September 2006 - 07:13 PM
However - My isp has a insert/update limit of 36.000 rows per hours - so its a real time-spender
Then i was tipped about the bulk insert possibility, from the mysql manual:
INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);
Now, i havent startet rebuilding my update/insert script for this yet, as i'm not sure how many bulks of values i can attatch in one query..... any oppinions on this ? I can hardly imagine that i can insert 100.000 rows on one query like this... or can i ???
Posted 08 September 2006 - 07:38 PM
Posted 09 September 2006 - 09:19 AM
Lock tables is not nessesary since this is a new table later to be renamed replacing another one, so no queries will be ran on it during insert.
I'll have to look on INSERT IGNORE what that means.
But why should i disable keys ??
Posted 09 September 2006 - 08:16 PM
I just rebuilt my insert parser and now it inserts 10.000 new rows in one query without any probs (havent fount the max_packet_size setting) - i also made a meta-refresh link in 5 sek intervals to parse the textfile until all rows is inserted.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users