Guru Prasad wrote: > > Dear All, > > I am using DBI version 1.19. I am using fetchall_arrayref function to get > all the records in a single strech. The table is having about 15000 > records. Now the memory occupied by the process increses by 20 MB. Once i > have finished processing the records, i am doing a proper > 'undef' to the array to release the memory. But it's not happening. Can it > be sorted out in program itself or at DBI level or is it a problem in perl > itself.
Is it really absolutely necessary to get thw whole database at once? The best way to avoid this problem would be to handle one record after the other and put as much action as possible to the server via SQL. -- Helmut A. Bender Verlag Hans Schöner GmbH, Königsbach [EMAIL PROTECTED]
