[eluser]mddd[/eluser]
You are welcome. Some more tips that might help you:
Try combining INSERT statements. For instance:
Code:
INSERT INTO table SET col1='value1', col2='value2'
INSERT INRO table SET col1='value3', col2='value4'
can also be written as:
Code:
INSERT INTO table (col1, col2) VALUES ('value1','value2'), ('value3', 'value4')
It will be quicker because you are sending less separate queries to the database.
If you are writing a LOT of information, it can often be quicker to write all the data to a file first, and then load the file with the LOAD DATA INFILE command. But this does require 'file' rights in Mysql. If you are on shared hosting you may not have those rights.