mysql - handling bigdata from excel in php -


this opinion based question. let have excel file 4k row , 50 column. have handle file in step step. here mention steps

  1. validate every field of every row. (here mysql query run checking database related validation)

  2. if data valid have save data in 3 table , update 1 table
    example
    column 1-20 insert in table_1
    column 21-40 insert in table_2
    column 41-50 insert in table_3
    update table_1 last insert id of table_2 , table_3

now want know best practice handle big data. suggestion compatible php, cakephp or laravel

now want know best practice handle big data.

as handle other "big data" well: read , process in chunks of given size each chunk fits limitations of system.


Comments

Popular posts from this blog

tcpdump - How to check if server received packet (acknowledged) -