Maximum size
Can anybody help me?
I am trying to create a database for the management of a warehouse with about 25,000 items and it is blocked.
What I can do?
It does not work in the Mac App or in the cloud.
Thank you!!
4 replies
-
How many tables are in the database and how many columns per table? What are the column data types: numbers, text, images, etc. I assume the 25,000 "items" are records. Were they created manually or imported? What do you mean when you say the database is "blocked". Are you unable to enter the database, or unable to view a table, or something else?
-
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 fileThe 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?
-
You did not mention a "loop" in your first post. Please provide more detail about what you "loop" is doing and when it is "blocked". If you can provide sample code, that might help.
-
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
Content aside
- 4 yrs agoLast active
- 4Replies
- 997Views