Skip site navigation (1) Skip section navigation (2)

Re: Regarding mulitple rows insert in one shot using ADO .net connected to postgres

From: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
To: keshav upadhyaya <ukeshav2009(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Regarding mulitple rows insert in one shot using ADO .net connected to postgres
Date: 2009-10-08 07:02:06
Message-ID: 65937bea0910080002k36d9c6fexce8e95ce88e99f59@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
Try the multi-row INSERT syntax:

From the docs:

 To insert multiple rows using the multirow VALUES syntax:

INSERT INTO films (code, title, did, date_prod, kind) VALUES
    ('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'),
    ('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy');


Best regards,

On Thu, Oct 8, 2009 at 12:09 PM, keshav upadhyaya <ukeshav2009(at)gmail(dot)com>wrote:

> Hi ,
>
> I want to insert multiple Rows in one shot to improve my performance .
>
> From C# code I am using ADO .net to connect to postgres .
> Currently i am pasting the code which is not of postgres but in my dev
> environment similar things  i am doing with Postgres.
>
> MySqlConnection mySql = new MySqlConnection();
>         mySql.CreateConn();
>         mySql.Command = mySql.Connection.CreateCommand();
> *        mySql.Command.CommandText = "INSERT INTO dbo.table1 (textBox1,
> textBox2) VALUES (@textBox1, @textBox2)";
>
>         mySql.Command.Parameters.Add("@textBox1", SqlDbType.VarChar);
>         mySql.Command.Parameters["@textBox1"].Value = TextBox1.Text;
>         mySql.Command.Parameters.Add("@textBox2", SqlDbType.VarChar);
>         mySql.Command.Parameters["@textBox2"].Value = TextBox2.Text;
>
>         mySql.Command.ExecuteNonQuery();
>
> *        mySql.Command.Dispose();
>         mySql.Connection.Close();
>         mySql.CloseConn();
>
>
> Hi i have hilighted the line in  which I wanted to ask doubts .
>
> Currently i am inserting one row in one time and then executing the query .
>
> So with this approach i need to execute it many times for multiple rows
> insert because of this my database is poor in doing this each time for very
> large data.
>
> What i want here is to insert multiple rows and then executing it in one
> time only so that it will be faster.
>
> Please help me out in this regards .
>
> --
> Thanks,
> Keshav Upadhyaya
>



-- 
Lets call it Postgres

EnterpriseDB      http://www.enterprisedb.com

gurjeet[(dot)singh](at)EnterpriseDB(dot)com

singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com
Twitter: singh_gurjeet
Skype: singh_gurjeet

Mail sent from my BlackLaptop device

In response to

Responses

pgsql-novice by date

Next:From: keshav upadhyayaDate: 2009-10-08 07:29:46
Subject: Re: Regarding mulitple rows insert in one shot using ADO .net connected to postgres
Previous:From: keshav upadhyayaDate: 2009-10-08 06:39:36
Subject: Regarding mulitple rows insert in one shot using ADO .net connected to postgres

pgsql-performance by date

Next:From: keshav upadhyayaDate: 2009-10-08 07:29:46
Subject: Re: Regarding mulitple rows insert in one shot using ADO .net connected to postgres
Previous:From: keshav upadhyayaDate: 2009-10-08 06:39:36
Subject: Regarding mulitple rows insert in one shot using ADO .net connected to postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group