Posted by Aggelos on 10/30/06 19:32

Thanks for the reply. I allready use LOAD DATA INFILE to import... and
I do that fine.
The problem I found by looking my running processes using the command
"top" is that MySQL was busy for 3hours running select statements
because in my foreach loop of 40.000 records array I had only IDs and I
needed to get foreach ID the full details from another table.
So the solution I found is to make one big select and then have all the
Data I want stored in an array.

The problem is that I still get that Open/Save Dialog box on firefox
and I had that a few other times in other scripts as well.
Maybe is the server configuration, but then again I had that in both a
RAQ and a BSD box.

I still need someone with previous experience on what I am getting in
order to find an answer.
Both my import and export scripts work fine with 1000 records. The
problem starts when I increase the size of data.

Thanks again.

[Back to original message]