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
validate every field of every row. (here mysql query run checking database related validation)
if data valid have save data in 3 table , update 1 table
example
column1-20
insert intable_1
column21-40
insert intable_2
column41-50
insert intable_3
updatetable_1
lastinsert id
oftable_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
Post a Comment