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 bigg

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

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. http://dev.mysql.com/doc/refman/5.5/en/load-data.

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 select

Re: Which database?

cc: Kaarel <[EMAIL PROTECTED]>, [EMAIL 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

Re: Which database?

e out just 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

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]

Re: Which database?

mpany 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: > (...)

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?

MAIL PROTECTED] cc: 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

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 > th

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 co

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 developm

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

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 da

Re: Which database?

o use 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, 200

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 - MySQ

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/ ---