Parsing xlsx on 30,000 lines from php on hosting



  • The challenge is: Take a price of 30,000 lines and ideally compare it to the existing table per 1,000 lines (update prices, overall).

    In least, we just need to put the contents of the xls in a separate table.

    I'm so sympathetic that the script falls on the first thousand lines.

    Is there any way to solve the task? (Can't you get a lump in MySQL to feed, or as an option, to keep the xls file on the host and on demand for the goods, search the price directly in the xls file (through the artikul). But there's got to be some way to search the xls file from the PHP.

    xlsx weighs 1.5 mb when translated xls - 4.5.

    Anyway, who has faced such a challenge, please help me from where to start. Thank you.



  • First, we need data to normalize, make a good reading, better in csv. The search can be done in mysql, just writing the lines. It's different. Using battlefields and battlefields to create battlefields for each characteristic.
    Where the characteristic of x will be the battlefield 01011, which means that the properties of lines 1, 2, 4, 6 have a value x. Next time we need to filter, we're going to beat and or OR, or we'll combine both. Next, we'll just figure out the positions of the listed bats that indicate the numbers. One feature of the battlefield with 30K lines is 3.6 kilobytes.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2