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

increase write speed to UDB

P: n/a
Hi,

We essentially have
(about 1000/sec) messages coming through a channel and I have to store
them in a UDB database. Will UDB be able to write it that fast? If
not what are a few strategies that I could implement to get over this
problem? I am relatively new to
databases, but have programming in java for a while.
A concept that has been thrown at me is "load balancing". Not sure how

it works or if it is the best approach for this. Can someone offer
suggestions?
Thanks.

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
One way to increase insert speeds is to turn on append mode.

This will force DB2 to add the next record at the end of the table
instead of looking for a possible place to "plug" it in.

Also make sure you have a minimal amount of indexes on the table, since
updating an index at every insert is constly.

Hope these suggestions help.

Christos Kalantzis

du******@gmail.com wrote:
Hi,

We essentially have
(about 1000/sec) messages coming through a channel and I have to store
them in a UDB database. Will UDB be able to write it that fast? If
not what are a few strategies that I could implement to get over this
problem? I am relatively new to
databases, but have programming in java for a while.
A concept that has been thrown at me is "load balancing". Not sure how

it works or if it is the best approach for this. Can someone offer
suggestions?
Thanks.

Nov 12 '05 #2

P: n/a
also foreign key can reduce insertion speed since database should check
parent table for key existance.

regards,
Andrew

Nov 12 '05 #3

P: n/a
du******@gmail.com wrote:
Hi,

We essentially have
(about 1000/sec) messages coming through a channel and I have to store
them in a UDB database. Will UDB be able to write it that fast? If
not what are a few strategies that I could implement to get over this
problem? I am relatively new to
databases, but have programming in java for a while.
A concept that has been thrown at me is "load balancing". Not sure how

it works or if it is the best approach for this. Can someone offer
suggestions?
Thanks.

Hard to tell without having any details.
How big are your messages?
What is your hardware like?
What Operating system?
Are you using a DB client or is your program running on the server?

If your hardware is not fast enough, then you could try alternatives
like first writing to a flat file, which you import later or perhaps
buffering the incoming messages and write a number at the same time.

--
Anton Versteeg
IBM Netherlands
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.