limelect

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 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.

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

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 !!!

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
 

trying to compile d10.2.3 missing components