Maximum size

Good afternoon:

Let's see if I can answer all the questions:

- there are about 20 tables with 5 average columns per table
- the data is numbers or text, simple data
- yes they are records
- I have defined them manually but I get the data daily by importing a .csv file

The time it takes to fill in some data through a loop is about half an hour. The loop has 25,000 iterations and must read and write three data per iteration.

Could it be due to poor optimization of the database and formulas?

Hello:

this is the code that takes 45 minutes to execute.

let myCat := cnt(select 'Catálogo');
let myRF := last(select 'Stock diario');
let myF := myRF.Fecha;
if myF = 'Fecha de actualización' then
0
else
'Fecha de actualización' := myF;
for i in select 'Catálogo' do
let myRegCastelar := last(select 'Stock diario' where Fecha = myF and 'Almacén' = 1 and 'Catálogo' = i);
let myNCastelar := cnt(myRegCastelar);
if myNCastelar = 1 then
if myRegCastelar.Actuales > 0 then
i.('Actuales Castelar' := 0)
else
i.('Actuales Castelar' := myRegCastelar.Actuales)
end
else
i.('Actuales Castelar' := 0)
end;
let myRegCastellon := last(select 'Stock diario' where Fecha = myF and 'Almacén' = 2 and 'Catálogo' = i);
let myNCastellon := cnt(myRegCastellon);
if myNCastellon = 1 then
i.('Actuales Castellón' := myRegCastellon.Actuales);
i.('F. Caducidad' := myRegCastellon.'F. Caducidad');
i.('Ubicación' := myRegCastellon.'Ubicación')
else
i.('Actuales Castellón' := 0)
end;
i.(Actuales := i.'Actuales Castelar' + i.'Actuales Castellón');
i.(Valor := i.Actuales * i.PVP)
end;
let myR := (create Resultados);
myR.('Fecha de los datos' := myF);
'Referencias anuladas' := null;
'Referencias en rotura' := null;
'Referencias negativas' := null;
'Líneas caducadas' := null;
'Este mes' := null;
'Mes +1' := null;
'Mes +2' := null;
'Mes +3' := null;
'Referencias positivas Castelar' := null
end