11 May
2010
11 May
'10
12:05 a.m.
Iñaki Baz Castillo wrote:
2010/5/10 Juha Heinanen <jh(a)tutpro.com>om>:
Out of memory.
In early days, with "fetch" support, you could encounter problems when
restarting *ser if there were a lot of entries in location table as all
of them had to fit into memory (I private memory, but can't remember the
details). So the workaround was to increase memory but that was
inefficient as the memory was needed only during startup.
Now with "fetch" support this problem is gone as only the currently
fetched rows have to fit into the memory.
regards
klaus
Iñaki Baz Castillo writes:
I understand. And could one of these db experts tell us the exact
problem it could occur?:) Hi Juha, I don't fully understand what you
mean. Which parameter do
you mean? do you say that 1.5.4 permissions module is not suitable for
thousands of records. This would be a big handicap in my plattform.
modules that loads lots of records from db usually have a parameter,
such as lcr's fetch_rows, that tells how many records to load at one
shot. db experts can tell, why this is a good idea and what problems
may happen if such a param does not exist. there are no problems with
using the addresses once the records have been successfully loaded.