limelect

@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

@programmerdelphi2k I sent you a private message

@programmerdelphi2k It worked on my test bed but on the real application as you can see. Same Database size and content

@programmerdelphi2k I do not believe your solution did it.But it did also, it is on my test program I now will move to my main program MyMemStream:= ProjectsFDTable.CreateBlobStream(ProjectsFDTable.FieldByName('Description'),bmRead); AdvRichEditor.BeginUpdate; AdvRichEditor.LoadFromStream(MyMemStream); AdvRichEditor.EndUpdate;

@programmerdelphi2k trying your suggestion

@VandrovnikRunnig the program No oparation just openning the DATAbase

@VandrovnikFD has unidirectional i tried it allready when I activate it in the object inspector it gives an error

Number 4 in my description It is a ftBlob 4. leaving only one large record in the database, NO PROBLEM. Record size 61094574. If I leave 1 record NO PROBLEM. it has nothing to do with DB. Only the Delphi program This is what I think and I might be wrong Maybe you have something? I read the blob into a string then St := TStringStream.Create(s); AdvRichEditor.LoadFromStream(St); If the above works on any small record it is not the logic.

1. It will be too complex to split the data as it is text and pictures going into TAdvRichEditor 2. As seen from my explanation I clear all the records and left only with one record big one And this is OK. 3. I free all the connections and database as it will not have any effects and left with one record in-memory database that did not help. This supposes to have smaller program memory. It did not. 4. Once the program uses a large chunk of memory I am stacked with it. I made hundreds of professional programs making money out of them never had such behavior.

Tried to help Sorry

FMX uses // RTL System.UITypes, System.Classes, System.SysUtils, // FMX FMX.Memo, FMX.Types, FMX.Graphics, FMX.Controls.Model, FMX.Controls.Presentation; am I wrong?

Google search FMX RICHEDITE i found a few for example https://github.com/DelphiWorlds/KastriFree/blob/master/Controls/DW.RichEdit.pas

I have a text (it is a directory) I would like to find in a DB. My SQL which is OK FDQuery4.SQL.add('WHERE MainDirectory LIKE ''%' + jvDirectoryEdit1.Text + '%''' Now to the problem If my DB text is G:\Delphi Projects\image32_3.2.2\ and I am looking for G:\Delphi Projects\image32_3.2.2\ or G:\Delphi Projects\image32_3 My above statement finds it NO PROBLEM HOW EVER if my search is G:\Delphi Projects\image32_3.2.2\Examples\Layers101 My above line does NOT find it. What I also tried is using CHARINDEX which I may be did not use correctly So w.hat I am looking for is search text WITHIN my DB text Any idea thanks