|
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.
Navigation:
[Reply to this message]
|