On Sep 1, 2011, at 9:40 AM, Mathieu Dionne wrote:
> Im currently testing outside an active 4d base… But its goin to take a while
> since that method is very very big. It loops lot lot lot data…
Not sure what [Active4d-dev] DISTINCT VALUES and MULTI SORT ARRAY has to do
with your problem since you didn't say what type of data manipulation you are
doing.
If you are creating NEW arrays or collections in your loops without clearing
the old collections or arrays, you could be eating up vast amounts of memory,
which leads to slower and slower performance. I have experience in this area:-)
If you create new collections in a loop, make sure you "clear" collection at
the end of the loop.
while ..
$foo := new collection
.. add stuff to foo and write to DB
clear collection($foo)
end while
Steve
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
