increase write speed to UDB

dufffman

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

Subscribe Post Reply

1576

Christos Kalantzis

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

andrew dman

also foreign key can reduce insertion speed since database should check
parent table for key existance.

regards,
Andrew

Nov 12 '05 #3

Anton Versteeg

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

Similar topics

How increase a C/C++ Program speed ?

by: RAYYILDIZ | last post by:

I Know C is the fastest progrmming language. However, by using some bitwise operation you can get faster the your program. For instance, we talk about swap function. For a integer swapping we use...

C / C++

Explanation requested for this speed increase

by: velthuijsen | last post by:

I have a function that before I modified it took around 13.75 seconds to complete after the modification it took .325 seconds to complete. the function header: (Point **Input, size_t InputSize,...

C / C++

used pages increase after deleting and loading again

by: Olaf Gschweng | last post by:

We're new into DB2 and have some problem with DB2 8.1 (?) on a Linux system. We load some big tables of a DB2 database from files every day. We do a "DELETE FROM table" for each table and then we...

DB2 Database

How to increase the speed of this program?

by: HYRY | last post by:

I want to join two mono wave file to a stereo wave file by only using the default python module. Here is my program, but it is much slower than the C version, so how can I increase the speed? I...

Python

Increase speed when retrieving data from a Hosted SQL SERVER into VBA

by: Jakob Petersen | last post by:

Hi, I need to increase the speed when retrieving data from a hosted SQL Server into VBA. I'm using simple SELECT statements. How important is the speed of my Internet connection? (I have...

Microsoft SQL Server

execution speed increase after compile py code into exe?

by: Kelie | last post by:

hello, would there be any speed increase in code execution after python code being compiled into exe file with py2exe? thanks, kelie

Python

How Can I Increase the Speed of a Large Number of Date Conversions

by: vdicarlo | last post by:

I am a programming amateur and a Python newbie who needs to convert about 100,000,000 strings of the form "1999-12-30" into ordinal dates for sorting, comparison, and calculations. Though my script...

Python

Why doesn't performance increase too mcuh in multi threading? Please help

by: AliRezaGoogle | last post by:

Dear members I am working with a 2000 GH P4 Intel, and 512GB RAM. I have a long list matrix 3000 * 15,000 of type double. I have a calculation procedure which can be executed on any single...

C# / C Sharp

Want to increase upload speed : php

by: Devang | last post by:

Hello, I am using php script to upload file. some times if file size is too big(1GB) it takes too much time to upload. Can someone suggest me the way to increase upload speed. thanks

PHP

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server