limelect

I need your advice returning to my problem -out of memory. I have this free program https://limelect.com/downloads/document-projects/ that came out of my need. After 40+years of pascal/Delphi, I have a large number of projects/programs I do not even remember their content categories and more. The record includes text category pictures and more describing the source and program. Just started and I have 730 records with a 1.56 GB database (FireDac) size. So fixing the software does not seem to have an option? My DB file will grow to be very large. 1. I suspect I will have thousands of records 2 What is the theoretical size FireDac can handle? 3. Is it possible to fix my program with software? 4. I was thinking of splitting the DB. 5. Can the DB be manipulated on disk and not on RAM? 6. I am looking for a solution that will NOT cost money as it is a free program. 7. Installing other software like MS SQLserver is not an option. 8. I need a local/or any solution. 9. On a commercial program I have in a company I use MS SQLserver 2008 without any problems. Years of work and no problems. What are my options? Or what is my thinking wrong? Sorry if my need is too long.

For now, everything works. I will work with the program for weeks and see what happens.

@Hans J. EllingsgaardAll searches are with query For now, the search is OK. I changed the SQL statement . P.S Empty searches do make memory problems. The strange behavior is now on insert where I cannot pinpoint the problem. I am not sure where is the problem yet.

@Hans J. Ellingsgaardmaybe it is feasible for a search but not for insert where I have that problem too. While searching for a solution on searach I found that if I have an EMPTY text to search I get a memory problem

I use query and table. It seems that query has the problem I will write a test program for 1 query and see what happens

@Lars FosdalThanks I thought so too but did not find any external something to Delphi. It is close to us (Delphi). I loved the use of it since it has no DLL.

@Lars Fosdal It seems that most pas files associated with FireDAC are not accessible. Furthermore, is there a way to know what is going on with my SQLite? while executing? DEBUG? I think this is not given by Delphi. So I will revert to my test as I wrote before.

@Lars Fosdal Thanks i will check it

The leak is not a problem to a professional

@Vandrovnik YES . Actually, no need if you have FastMM4, if TogFirst.IsFirstInstance then begin ReportMemoryLeaksOnShutdown := True; Application.Initialize; Application.MainFormOnTaskbar := True; Application.CreateForm(TForm1, Form1); Application.CreateForm(TfmDropDown, fmDropDown); Application.Run; end else TogFirst.ActivateFirstInstance;

@Lars FosdalNo leak first thing I do to check it. uses FastMM4,

@Lars Fosdal you are correct my DB is SQLite. When I SQL or add records all gives me memory problems. What I think I will do I will write an investigation program with my actual database to analyze my use so I will decrease the program to a manageable logic of one function.

@David HeffernanBy no means I am willing to redesign the DB concept if I knew there is a good solution like MS server for example. The only problem I will not give my user to install the MS server. Why I wrote my problem because someone might come up with a good dB that i do not know

I have been using for years https://github.com/yktoo/dklang

D10.2.3 I could not find any ICON to put on my toolbar for Code folding. is my only option is Ctrl+Shift+K+O ?

Rx librery in it use RxDateUtil.pas

@Fr0sT.Brutalsorry you are correct but Delphi search did not find it now it does

@Fr0sT.Brutal No Ice.Utils.GetCurrentAddress such function in your source now it does

Fast search for Delphi hwid https://theroadtodelphi.com/2010/12/02/generating-a-unique-hardware-id-using-delphi-and-the-wmi/

This is what I did with Delphi for youtube-dl, ffmpeg https://limelect.com/downloads/youtube_downloader_shell/ is this what you are trying to achieve? Myne is only window and VCL

My application has an out-of-memory error On the break the source wants FireDAC.DatS.pas which I do not have Any idea how to solve this? if possible P.S after the out of memory if i keep going it is ok The part that does it is ProjectsFDTable.Filtered := false; ProjectsFDTable.FilterOptions := [foCaseInsensitive]; case RadioGroup2.ItemIndex of 0: begin //'%a%' ProjectsFDTable.Filter := {QuotedStr} 'ProjectrealName LIKE ' + QuotedStr('%' + Edit6.Text + '%'); <<< end; 1: begin end; 2: begin ProjectsFDTable.Filter := {QuotedStr} 'Category LIKE ' + QuotedStr('%' + Edit6.Text + '%'); end; end; ProjectsFDTable.Filtered := True; However, I am not sure it is only here !!! but this is where i could trace the out of memory

Thanks, guys I hope it is fixed I changed my table to Fetchoptions all i hop it fixed it and the search is faster

@Clément the only thing I see on FDTable is on FetchOption.mode is already fmOnDemand Let me clarify the point. Memory happens ONCE. Then everything is ok. If there was a real memory problem it should have been all the time want it? I am filtering the database upon writing a search text Each char one enter does a new filter. To be exact on >>>> procedure TForm1.Edit6Change(Sender: TObject); (my database file 1.55GB)

@Lajos Juhász first can you clarufy. second, if you are right once I get the memory msg and I dismis the message I do NOT get any more messages. The memory message is ONLY ONCE !!!

trying to compile d10.2.3 missing components