How ever after 6000 products the search slows down a lot?

Please attach your project, I will test it.

Hello.

Unfortunately can't find your project, please send me again to support@drive-software.com

Unfortunately I don't know how to use and test your project, please provide login/password and step by step details how to reproduce slow works.

First I see form "Versione non registrata"

Please provide step by step details how to reproduce slow works.

I don't know your project, but I have found out on my projects that the SQLite Database could be slower on a network folder.

Depending on the SQL Statement Structure the Database is up to 10 times slower if the database is located on a network folder as if it is on a local folder.

A software business partner told me this could happen on some older versions of the SQLite engine. Normaly it could slow down only if you have more as 100.000 records in a folder.

Just my two cents...

Please change this event like this

procedure Prodotto_TableGrid1_OnChange (Sender: string);
var
   i,c: integer;
begin
    Prodotto.TableGrid1.Columns[5].Alignment := taCenter;
    c := Prodotto.TableGrid1.RowCount - 1;
    Prodotto.TableGrid1.BeginUpdate;
    for i := 0 to c do
    begin
        Prodotto.TableGrid1.Cell[2,i].TextColor := $00A00000;
        Prodotto.TableGrid1.Cell[8,i].TextColor := clgreen;
    end;
    Prodotto.TableGrid1.EndUpdate;
end;

or even:

procedure Prodotto_TableGrid1_OnChange (Sender: string);
begin
    Prodotto.TableGrid1.Columns[2].Font.Color := $00A00000;
    Prodotto.TableGrid1.Columns[8].Font.Color := clgreen;
    Prodotto.TableGrid1.Columns[5].Alignment := taCenter;
end;