By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,778 Members | 1,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,778 IT Pros & Developers. It's quick & easy.

Fastly Inserting Records

P: 18
Hello Friends,

In a Table I am inserting more than 50,000 Records one by one. It was taking a lot of time . Is it There any good approach/solution for inserting records more than 50,000 one by one in a fast manner. I have the same Problem in Updating of Records also. Please help me regarding this issue.

I am Using VC++ application As a Front End and libpq 'C' interface as a interface between my application and PostgreSQL Backend Database. when ever there is an error libpq interface is giving that error. But I would like to change the Message/Content That was coming from libpq interface. How Can I chnage the message/Content.

waiting for your valuable reply.

ThanQ
Feb 25 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 534
There is a number of factors that can impact performance of your application, and what you posted is not nearly enough to suggest any improvements.

Depending on where you get these data (select from other tables?) you may be able to do something more efficient than individual insert for every record.

You need to make sure that slow performance is not related to scarce system resources (are you getting enough CPU, for example?)

Too many indexes on the table will slow down any DML operations, so make sure you have only what you need.

Also there is a number of configuration settings that can affect performance
(see postgresql.conf and database run-time parameters)

Depending on the platform (Windows, Solaris, etc) and the version of Postgresql there could be more tips on performance.

Last, but not least the schema itself sometimes needs to be optimized for performance.

I don't quite understand the second question; are you talking about error messages you get from PQerrorMessage or PQresultErrorMessage?
Feb 26 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.