limelect

@Dalija Prasnikar see in one of my answers I even free all used components DB and link nothing helped. Once the program reaches max memory nothing helps But if I use 2 programs just for testing see above it works. Even on the same DB

@Anders Melander I answered that way of thinking. Your proposal is too basic

Crazy as it sounds I executed my main program Then concurrent I executed my TEST program which it does read this record into richedit. Well, both programs are in memory and it worked on my test program. However, twice the DB as I did not want a lock condition. Just to check the loading of the record

@Dalija Prasnikar That is the time to say "Don't use memory stream to load data to rich edit. Create temporary file and write the data into that file and then load the data from the filestream." I tried all ready weeks ago

@Lars Fosdal It was so simple programming just to copy to richedit without any processing.

@sherlock I do not blame but myself. I started with Delphi with #1 and before with visual and before with Pascal,c, and more. There were days I wrote with FORTRAN. I never had such a problem not even with BDE. I just finished making a large program that handles all company need with MSSQL. many PC, a lot of electronics, and no memory problems. The thing I blame is the components (not Delphi?) as they use a lot of memory. Not my Pascal writing and I might be wrong. @Lars Fosdal It will be too complicated but I will think about that option. What you suggest is when reading to assemble all pictures that were in records. maybe. The only problem I have programs already out there what do I do with them?

@aehimself The DB is NOT the problem. Since data (a record) read OK. But the use of it. It finishes the memory. @Stano Files are not the problem as they are data. In my case, it is pictures and text as they are also data. Can be asci or binary does not matter. TAdvRichEdit uses this data with no problem

@Lars Fosdal I am writing you personally Furthermore, even if I fix this one record the record mite grow much bigger by the user than what?

@Lars Fosdal I just remembered one of my tests was to move the record into DBmemory close and free all links and DB and use the DBmemory. my thinking was maybe it will reduce total memory it did not.

@Lars Fosdal Unfornetly that is what I am doing. I filter the database and left in the dbgride with 1 record. It does not matter how many records are left. dblclick the record and read the field into the stream. No problem AdvRichEditor2.LoadFromStream(MyMemStream);<<< memory problem before I read the blobe into a string memory error It seems I have to redesign my program. because at another time the record might even be larger. I cannot know how many pictures and text richedit will hold. P.S what amazed me that insert into db has no problems

Programming is fun this is why I chose this profession 0 physical memory while the program executes

@Fr0sT.Brutal You are right or design the program differently Some programmers use many EXE in their program

@programmerdelphi2k Plz stops attacking me it does not help. And your demo is useless. @Attila Kovacs Debug does not help since I finish my memory and I know exactly when it happens when I load a large record. It is a program too large to be in memory. @Fr0sT.Brutal I know precisely what happens. At first time, I thought it was an SQL problem now I know it is a memory problem. @skyzoframe[hun] storing pictures into a file very fast I will have thousand of them. and this is exactly what I do "Or use a custom table for blob fields and call only when you have to show the picture." I insert it into a DB where I have no problem however bringing the record finishes the memory !!. P.S an Idea. if I put the form and process into a DLL load and unload each DLL (form) will it help for memory?

Right now from my point of view as a programmer, I catch the screen of a program as a picture copy to clipboard saves to ADVrichedit so simple.

@skyzoframe[hun] The only way to reduce Is to zip and then open. I am using advrichedit which holds pictures and text obviously this move to a database. There are more options to decrease the size of the picture however the whole program takes up a lot of space. However, I am allowing to put a few pictures in the record which will bring back the size problem. Maybe the best is to decode as your suggestion to EMF file However, advrichedit is streamed into the DATABASE so I have To see how to split the data and use it. Waaa it starts to be complicated P.S using ADVrichedit is great as it allows printing in many formats

@Fr0sT.Brutal for some reason I did not use Task manager As you can see the line is almost top of the screen Any suggestion? Software wise

@Fr0sT.Brutal number 4 in my first writing 4. leaving only one large record in the database, NO PROBLEM. Record size 61094574. Can you elaborate on how to see memory consumption while debugging do you mean to add software to the source at some points or there is an IDE tool for that which I never used? D10.2.3 To make it clear your way might help but how? I was trying to do what you suggested with vmmap.exe. I tried a while ago but did not see anything special. all numbers were fixed. Do you have a simpler tool? P.S on my test program which has only a grid and button same logic works which let me assume that components are involved

Sorry I cannot help My test program works with the same logic

@programmerdelphi2k Sorry not to agree as since on my test program with 1 grid and a few buttons, this same database is reading all records even the large record. I suspect as the full program has lots of components altogether are the problem. Somehow the combination does the problem. P.S I send you the source for the test program and the database see the 5'th record and the test read it

@Hans J. Ellingsgaard yes by now I tried all combinations. See above my last resort moving 1 record to memory freeing all components and using in-memory just 1 record tough large but only 1. I am left with no choice but to find which component/components have an impact on the program I am confident now that it is not only the database since I can insert, delete, change and do any manipulation on it. except for reading one record under the search condition. The search condition applies to all records with no problem only the use of 1 record. P.S all other records can be read (and there are more than 700 of them) with no problem. At the beginning of the problem, I started with SQL only then I changed to combination of table and SQL.

Well as a last resort to find what's making the problem I developed many years ago what I call "scrounge the software" which means taking parts of the program/or components out until you reach what is your problem Obviously, work only on a copy of your program. A lot of work but worth the self-teaching

If someone wants to see Delphi in action goto https://limelect.com/product-weighing-software-page/ A crystal growing machine 2 years in development with Delphi 4. A weighing machine with a PC card and Delphi with D6 and 7 And many more.

Whoever wants to see which free program we are talking about https://limelect.com/downloads/document-projects/ The main picture does not show how many pages there are. Inserting has no problem

@aehimself I thought so too. One of my tests was to delete all components involved Just one record !!!! FDMemTable1.CloneCursor(ProjectsFDTable);<< Move record to memory table // FDMemTable1.RecordCount << check to see if data is inside >>>>>> Close and free all databases and even connections!!! ProjectsFDTable.Close; FilesFDTable1.Close; FDConnection1.Close; ProjectsFDTable.Free; FilesFDTable1.Free; FDConnection1.Free; FDMemTable1.FieldByName('Description').AsString;<<< Then use the record or this MyMemStream:= ProjectsFDTable.CreateBlobStream(ProjectsFDTable.FieldByName('Description'),bmRead); crazy as it sounds memory problem. "That should minimize the memory usage." It did not

@Daniel all I meant by this thread is that my test program just a DB grid and a few buttons the LOGIC is OK but on my full program with the same logic, I have a memory problem. I did not expect anyone to solve the problem as it is NOT a logic nor an SQL problem which I thought at the beginning. but a BIGGER Delphi problem as my main program is full of components forms and more. I never saw such behavior with hunters of projects behind me. This is a warning to the Delphi community about what to expect. And finally, I hope I am wrong. P.S I will keep looking into this problem