Which Database when lot of insert / update queries to execute

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

Re: Which Database when lot of insert / update queries to execute

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.

RE: Which Database when lot of insert / update queries to execute

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.netj...@gmail.com] Sent: Friday, June 15, 2012 1:57 AM To: mysql@lists.mysql.com Subject: Which Database when lot of insert

Re: Which Database when lot of insert / update queries to execute

2012/06/15 18:14 +0900, Tsubasa Tanaka try to use `LOAD DATA INFILE' to import from CSV file. http://dev.mysql.com/doc/refman/5.5/en/load-data.html Try is the operative word: MySQL s character format is _like_ CSV, but not the same. The treatment of NULL is doubtless the biggest

Which database?

Hi I am fairly new to databases, but my boss has assigned me to choose a database system for our company. I know of Oracle databases but they are way too expensive so it's not an option for us. I did some research and came up with two free database systems that seemed to be more popular -

Re: Which database?

PostgreSQL at some point in time, if only for curiousity's sake, I'm glad I started with MySQL. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Kaarel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, 10 June, 2003 07:38 Subject: Which database? Hi I am

Re: Which database?

# [EMAIL PROTECTED] / 2003-06-10 14:38:49 +0300: I am fairly new to databases, but my boss has assigned me to choose a database system for our company. I know of Oracle databases but they are way too expensive so it's not an option for us. I did some research and came up with two free

Re: Which database?

Actually, the license might turn out to be your biggest problem, especially if arter six months of development it turns that you either have to pay for MySQL or rewrite your application using another database. Note that I don't know the MySQL AB pricing scheme, and I'm

RE: Which database?

Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 14:04 To: [EMAIL PROTECTED] Cc: Kaarel; [EMAIL PROTECTED] Subject: Re: Which database? Actually, the license might turn out to be your biggest problem, especially if arter six months of development

Re: Which database?

# [EMAIL PROTECTED] / 2003-06-10 14:11:39 +0100: (...) lack of commercial support company means you are unlikely to get the same level of support. unlikely? perhaps. but... how many OS programs do you use, how many of them have commercial support, and how do those that have

RE: Which database?

Peter -Original Message- From: Roman Neuhauser [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 14:43 To: [EMAIL PROTECTED] Subject: Re: Which database? # [EMAIL PROTECTED] / 2003-06-10 14:11:39 +0100: (...) lack of commercial support company means you are unlikely to get the same level

Re: Which database?

: Subject:Which database? Hi I am fairly new to databases, but my boss has assigned me to choose a database system for our company. I know of Oracle databases but they are way too expensive so it's not an option for us. I did some research and came up with two free database

Re: Which database?

On Tue, Jun 10, 2003 at 10:54:52AM -0400, Peter J. Milanese wrote: Hey Kaarel- I've been sticking with MySQL mostly for it's support. Large community, lots of documentation, and they have a future plan (which they tend to actually complete ahead of schedule). Wow. You must be the first

Re: Which database?

means you are unlikely to get the same level of support.' P Roman Neuhauser [EMAIL PROTECTED] 06/10/2003 09:42 AM To: [EMAIL PROTECTED] cc: Subject:Re: Which database? # [EMAIL PROTECTED] / 2003-06-10 14:11:39 +0100: (...) lack of commercial support

Re: Which database?

subselects were slated for release with 5.0 Not 4.1 P Jeremy Zawodny [EMAIL PROTECTED] 06/10/2003 11:21 AM Please respond to mysql To: Peter J. Milanese [EMAIL PROTECTED] cc: Kaarel [EMAIL PROTECTED], [EMAIL PROTECTED] Subject:Re: Which database

Re: Which database?

what your requirements are and then see which database suites your needs. If you need to work with extremely large databases (multi GB) I would go with MySQL. It scales to large files extremely well. Curtis Maurand On Tue, 10 Jun 2003, Becoming Digital wrote: You're on the MySQL list, so

Re: Which database?

PROTECTED] Subject:Re: Which database? On Tue, Jun 10, 2003 at 10:54:52AM -0400, Peter J. Milanese wrote: Hey Kaarel- I've been sticking with MySQL mostly for it's support. Large community, lots of documentation, and they have a future plan (which they tend to actually complete

eWeek Poll: Which database is most critical to your organization?

Good Day All, eWeek has posted a poll that asks which database server is most critical to your organization. The poll tracks the following databases: - IBM DB2 - Informix - Microsoft SQL Server - MySQL - Ingres - Oracle - PostgreSQL - Sybase Adaptive Server Enterprise - Sybase SQL

Which Database?

I am using a binary installation of MySQL for Linux 7.1...how do I tell what database it is configured to use for the backend? InnoDB or something else? -bryanw .BIZ, .INFO, .CC .COM, .NET, .ORG Pre-register your .NAME address now! http://www.halfpricenames.com/