in reply to DB Question, speed is the answer!
But there is one thing in your while loop that could suck up lots of resources, and that's the pushing onto @array_account. If there's a lot to be fetched from the database, @array_account will get huge - and because it grows by bits and pieces, a lot of allocation of memory will happen. That will take time, specially if you're using significant amounts of it. Do you actually need all the data into one array?
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: DB Question, speed is the answer!
by Anonymous Monk on Jan 14, 2005 at 15:22 UTC |