Hello, > 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. try to use `LOAD DATA INFILE' to import from CSV file.
http://dev.mysql.com/doc/refman/5.5/en/load-data.html > Also , if i need to do 'group by', on a column on a large table what should > i keep in mind, is it advisable, create index on columns used by 'group by' and columns used by aggregate functions. regards, 2012/6/15 abhishek jain <abhishek.netj...@gmail.com>: > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
