Networking - i Need some packet capturing information...

Hi everybody.

I'm building an application on a server that has about 40 clients connected.

I need to capture packets, retrieve information from it and store that information into a database. I'm using MS Access.

Does accessing and updating the database overload the program?

Is there any possibility of losing any of the packets due to this overhead?

Should i keep the data in program memory and then update at regular intervals?

I need all of you who have some knowledge to comment on this to show me the right way..

Thank u guys..

[584 byte] By [elroydsilvaa] at [2007-11-26 23:04:12]

# 1

Does accessing and updating the database overload the

program?

Compared to what? This is a pretty meaningless question. Every second server in the world accesses and updates a database.

Is there any possibility of losing any of the packets

due to this overhead?

Not if you use TCP.

Should i keep the data in program memory and then

update at regular intervals?

Depends on your transactional design, but it probably requires you to commit every transaction when received.

ejpa at 2007-7-10 13:56:52 >

# 2

I'll be using a TimerTask for updating the database.Does this require commiting after each update.?

elroydsilvaa at 2007-7-10 13:56:52 >

# 3

Do you transactions require committing after every update? It isn't a performance question, it's a database integrity/business rule question.

ejpa at 2007-7-10 13:56:52 >

# 4

Alright.....Thnks.

elroydsilvaa at 2007-7-10 13:56:52 >

Core New Topic