IBM Data Management Community Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems. Join / Log in
In general Netezza doesn't like single row inserts/updates it was designed to work on queries for millions/bilions of rows. Many times those single row insert will take as much as inserting 1000 rows...
If you are running it in separate sessions it will take even longer.
Those single row inserts are running in parallell or sequentionally? Maybe just for this app user on scheduler rules and set priority to high (or even critical)? What is the background "noise" (how much of other processing is running)?
I think you're kind of stuck given that you are doing singleton inserts. Have you tried getting timings using an IDE to see if it is equivalent with using the 3rd party tool? Singleton INSERTS are the worst. If the box is completely idle, you may see better performance, but if there is utilization, you're likely waiting for other snippets to complete before it gets around to applying your insert. If there is a way you can avoid singleton inserts by using nzload or external tables, your throughput will improve remarkably.
Solutions Architect, Analytics / BI / Information Management
CONFIDENTIALITY NOTICE: THIS MESSAGE IS CONFIDENTIAL, INTENDED FOR THE NAMED RECIPIENT(S) AND MAY CONTAIN INFORMATION THAT IS (I) PROPRIETARY TO THE SENDER, AND/OR, (II) PRIVILEGED, CONFIDENTIAL, AND/OR OTHERWISE EXEMPT FROM DISCLOSURE UNDER APPLICABLE STATE AND FEDERAL LAW, INCLUDING, BUT NOT LIMITED TO, PRIVACY STANDARDS IMPOSED PURSUANT TO THE FEDERAL HEALTH INSURANCE PORTABILITY AND ACCOUNTABILITY ACT OF 1996 ("HIPAA"). IF YOU ARE NOT THE INTENDED RECIPIENT, OR THE EMPLOYEE OR AGENT RESPONSIBLE FOR DELIVERING THE MESSAGE TO THE INTENDED RECIPIENT, YOU ARE HEREBY NOTIFIED THAT ANY DISSEMINATION, DISTRIBUTION OR COPYING OF THIS COMMUNICATION IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE (I) NOTIFY US IMMEDIATELY BY REPLY E-MAIL OR BY TELEPHONE AT (855.472.9822), (II) REMOVE IT FROM YOUR SYSTEM, AND (III) DESTROY THE ORIGINAL TRANSMISSION AND ITS ATTACHMENTS WITHOUT READING OR SAVING THEM. THANK YOU.