Try limiting data buffer size with SYS(3050):
=sys(3050,1,50000000)
=sys(3050,2,50000000)
>VFP8
>
>I have an application that takes a file and store it in a table the patern is really simple and it's working great. But my application is not releasing it's memory it can grow up to 500 megabytes of ram.
>
>I only use local variable an I call my table my patern is
>
>INSERT INTO BackUp (mFilename, mFile) VALUES (FULLPATH(laDir(i,1)), FILETOSTR(laDir(i,1)
>
>(laDir is populated with ADIR())
>
>anyhelp will be appreciated
Jim Saunders
Microsoft
This posting is provided “AS IS”, with no warranties, and confers no rights.