Re: Long script strange behaviour
- From: "Aggelos" <djjelly@xxxxxxxxx>
- Date: 30 Oct 2006 11:32:16 -0800
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.
.
- References:
- Long script strange behaviour
- From: Aggelos
- Re: Long script strange behaviour
- From: AlexVN
- Long script strange behaviour
- Prev by Date: Bin packing problem
- Next by Date: Re: passing information
- Previous by thread: Re: Long script strange behaviour
- Next by thread: insert data -
- Index(es):