#11959: Import data slow performance as compare to ADS-14.0.11 on Informix database | Aqua Data Studio

Issues
Search Tips

Easily find issues by searching: #<Issue ID>
Example: #1832

Easily find members by searching in: <username>, <first name> and <last name>.

Example: Search smith, will return results smith and adamsmith
You can use:
- Boolean operators AND, OR and NOT (must be in caps, e.g. oracle AND debugger, debugger NOT oracle)
- Single and multiple character wildcard (e.g. de?ug, debug*)
- Grouping (e.g. ((oracle debugger) AND exception))
- Quoted phrase (e.g. "Oracle Debugger")

#loadingpage {display:none}JavaScript and Cookies must be enabled in order for you to use AquaClusters.here

Aqua Data Studio / nhilam

Follow 829

IDE for Relational Databases

Back

Raghvendra Singh

raghavsingh reported 2014-04-28T11:05:02Z · last modified 2014-09-06T16:02:29Z

Import data slow performance as compare to ADS-14.0.11 on Informix database

Dev	JennyNishimura
QA	tariqrahiman

Priority	Major
Complexity	Unknown

Component	Tools - Import Tool
Version	15.0

Product: Aqua Data Studio

Version: 15.0.0-dev-251

Build #: 37516

Build Date: 2014-Apr-24 02:29:32 PM

Operating Environment: Windows NT (unknown) (6.2, amd64)

Import data slow performance as compare to ADS-14.0.11 on Informix database

Aqua Data Studio 14.0.11
Transaction type	No. of Rows	Batch Size	Threshold size	Wait Time	Elapsed Time (in Sec)
Full	10000	0	0	-1	6
Full	50000	0	0	-1	31
Full	100000	0	0	-1	72

Aqua Data Studio 15.0.0-dev-251
Transaction type	No. of Rows	Batch Size	Threshold size	Wait Time	Elapsed Time (in Sec)
Full	10000	0	0	-1	17
Full	50000	0	0	-1	70
Full	100000	0	0	-1	138

All Comments (4) Change History

Tariq Rahiman

tariqrahiman 2014-06-24T20:23:39Z

@raghav: can you email me the table DDL and the import data so that I can reproduce the issue here in our labs

Niels Gron

NielsGron 2014-08-27T21:31:39Z

@raghav: Can we get a status update on this issue so that we can try to resolve?

Raghvendra Singh

raghavsingh 2014-08-28T11:50:42Z

@Neils

I have tried to check performance again in latest builds ADS-Version: 14.0.18 and ADS-Version: 15.0.0-beta-38.

Now this time ADS-Version: 15.0.0-beta-38 performance is better than ADS-Version: 14.0.18

Aqua Data Studio 14.0.18
Transaction type	No. of Rows	Batch Size	Threshold size	Wait Time	Elapsed Time (in Sec)
Full	10000	0	0	-1	11
Full	50000	0	0	-1	39
Full	100000	0	0	-1	52

Aqua Data Studio 15.0.0-beta-38
Transaction type	No. of Rows	Batch Size	Threshold size	Wait Time	Elapsed Time (in Sec)
Full	10000	0	0	-1	04
Full	50000	0	0	-1	18
Full	100000	0	0	-1	46

Raghvendra Singh

raghavsingh 2014-09-05T11:43:31Z

Verified in ADS- Version: 15.0.0-rc-17 performance is better than ADS-Version: 14.0.18

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017