Time to Insert records in a DB table

[Former Member]

Hi all

My requirement is to insert around 1000 record in a JDBC table .

How much time will this take ?

i am using PI 7.0 and SP is 16

and using ojdbc14.jar driver to access the database.

thanks

Regards

bhasker

[Former Member · Accepted solution]

Hi! Bhaskar

It should not take more than couple of seconds to a minute...Also, depends on how many messages (other than this interface) are running parallel at the same time.

Yeah, but at the most it should take a min or 2....and would increase if you have more columns too.

Regards,

Patrick

[Former Member · Accepted solution]

HI all

Thank u for ur feedback and suggestions

Regards

Bhasker

[Former Member]

Hi! Bhaskar

It should not take more than couple of seconds to a minute...Also, depends on how many messages (other than this interface) are running parallel at the same time.

Yeah, but at the most it should take a min or 2....and would increase if you have more columns too.

Regards,

Patrick

[Former Member]

Hi,

Check these links:

http://www.flickr.com/photos/8764045@N06/549186611/

http://www.flickr.com/photos/8764045@N06/549186651/

This will enable you to insert multiple records at a time. Also you can do such kind of thing for Stored Procedure. That will be much better.

Regards

[prateek]

In XI perspective, this would completely depend upon the hardware used for XI and the scenario configuratoin. e.g. your CPU and processor sizing, memory, way of calling the database etc.

Regards,

Prateek