Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Memory leak when reading blob fields
Fri, May 2 2008 8:11 AMPermanent Link

Manuel Sebares
Hi all. I am using D7 and Dbisam 4.25.

I have a database with some megabytes files (5MB to 25MB) stored in blob fields.

When I use the Blob SaveToFile routine in Local mode, the program takes memory and releases it after the operation.

When I perform the same operation in C/S mode, the memory is never released.
In this situation, if I close the table and open it again, it takes even more memory and slows down the performance of the database with a 100% CPU
consumption.

The only solution I have found is closing the session.

I have found many posts with the same problem in this newsgroup, but NONE of them shows solution to the problem.

Please, I need urgent help because if I do not solve this problem my current project will sink in C/S mode.

Thanks.

Manuel Sebares
Fri, May 2 2008 9:44 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Manuel,

<< When I perform the same operation in C/S mode, the memory is never
released.In this situation, if I close the table and open it again, it takes
even more memory and slows down the performance of the database with a 100%
CPU
consumption.  >>

How are you gauging the memory consumption ?   If it's the task manager,
then that's not going to be accurate for such purposes.   Also, how many
times are you calling SaveToFile and is 25MB the largest BLOB that you're
saving ?

I'm trying it here with 4.26 and a 34 meg Memo field (also a BLOB) and I do
not see what you are describing at all.  However, as of 4.26 we're using the
FastMM memory manager instead of our own, so that may account for the
difference.

<< I have found many posts with the same problem in this newsgroup, but NONE
of them shows solution to the problem. >>

Links, please ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Image