Please allow ads on our site
Kindly log in to use this feature. We’ll take you to the login page automatically.
LoginMass data upload from Excel - technology
General Tech Technology & Software 3 years ago
User submissions are the sole responsibility of contributors, with TuteeHUB disclaiming liability for accuracy, copyrights, or consequences of use; content is for informational purposes only and not professional advice.
No matter what stage you're at in your education or career, TuteeHUB will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.
Similar Forum
Explore Other Libraries
Online Exams
Question Bank
Career News
Feeds
Full Forms
Dictionary
Interview Question
Gigs
Quotes
Lyrics
Videos
Courses
Blogs
Tutorials
Forum
Educators
Corporates
Tools
Please allow ads on our site
Kindly log in to use this feature. We’ll take you to the login page automatically.
Login
manpreet![Tuteehub forum best answer]()
Best Answer
3 years ago
I am a Developer seeking help in terms of DB technology for a specific requirement. I have done some research but can not conclude with list.
Requirement: There will be a web application which will allow user to upload Excel document in specified format(expecting 1 Million of rows) and it will then Save somewhere in DB and run some calculation against our data base values. After that will present user with some numbers/chart based on calculations.
My first question is MySQL DB good enough for this requirement over any other DB like Postgres?
Second question is how much time will it take to upload 1 million rows of data from Excel, considering there will be 6 columns?
Third, which technologies should I consider to make this application fast and efficient like InnoDB, etc.
Once again I have done my research but I could not reach into conclusions, and any DB expert feedback/help will be highly appreciated.