List:General Discussion« Previous MessageNext Message »
From:Tsubasa Tanaka Date:June 15 2012 9:14am
Subject:Re: Which Database when lot of insert / update queries to execute
View as plain text  
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.netjain@stripped>:
> 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
Thread
Which Database when lot of insert / update queries to executeabhishek jain15 Jun
  • Re: Which Database when lot of insert / update queries to executeTsubasa Tanaka15 Jun
    • Re: Which Database when lot of insert / update queries toexecutehsv16 Jun
  • RE: Which Database when lot of insert / update queries to executeRick James15 Jun