Create PHP MYSQL database from excel files (4 crore codes)
₹1500-12500 INR
Pågår
Lagt ut nesten 6 år siden
₹1500-12500 INR
Betalt ved levering
I have 4 crore unique code database in various excel files. I want to create multiple small DB basis the first 5 digits of the codes (i.e. 81234 as one DB and 76543 as 2nd DB). I need multiple DBs since I have to run API and running query on such large datebase will take too much of time. I am using PHP and I am unable to upload files even with 10Lakhs code at once.
Hello. I am Andrey.
Just two day ago I finished project(PHP - Yii2 ), working with csv files.
I have seen screens and looks like script "ate" all free memory. I think you(or programmist) should impove algorithm of loading data...
I can help you for your problem.