0

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

null
    • Choices_Software_Dean
    • 3 yrs ago
    • Reported - view

    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?

    • Antonio
    • 3 yrs ago
    • Reported - view

    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?

    • Choices_Software_Dean
    • 3 yrs ago
    • Reported - view

    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.

    • Antonio
    • 3 yrs ago
    • Reported - view

    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

  • 3 yrs agoLast active
  • 4Replies
  • 988Views