From: abhishek jain Date: June 15 2012 8:57am Subject: Which Database when lot of insert / update queries to execute List-Archive: http://lists.mysql.com/mysql/227671 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=bcaec554d844807d6404c27f0074 --bcaec554d844807d6404c27f0074 Content-Type: text/plain; charset=ISO-8859-1 hi, I am biased on mysql, and hence i am asking this on mysql forum first. I am designing a solution which will need me to import from CSV, i am using my JAVA code to parse. CSV file has 500K rows, and i need to do it thrice an hour, for 10 hours a day. The Queries will mainly be update but select and insert also at times, The database size will be estimated to be about 5GB. I need to know is this a classic case for a NOSQL database or mysql is a good option. Also , if i need to do 'group by', on a column on a large table what should i keep in mind, is it advisable, Please advice, -- Thanks and kind Regards, Abhishek jain --bcaec554d844807d6404c27f0074--