From: Rick James
Date: June 15 2012 7:06pm
Subject: RE: Which Database when lot of insert / update queries to execute
List-Archive: http://lists.mysql.com/mysql/227681
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB1487607F58@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Let's see
SHOW CREATE TABLE ...
SELECT ...

It sounds doable with MySQL; might be too big for NOSQL.

> -----Original Message-----
> From: abhishek jain [mailto:abhishek.netjain@stripped]
> Sent: Friday, June 15, 2012 1:57 AM
> To: mysql@stripped
> Subject: Which Database when lot of insert / update queries to execute
>=20
> 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.
>=20
> Also , if i need to do 'group by', on a column on a large table what
> should i keep in mind, is it advisable,
>=20
> Please advice,
>=20
> --
> Thanks and kind Regards,
> Abhishek jain