Central Database Problem

Question

0.00/5 (No votes)

See more:

Hi everyone :)

I have a Store Management System for a company that have 4 branches and each branch have 4 system clients.

The 4 branches works on a central database over internet connection, the problem here is the data saving and retrieving are more slow.

So there is any solution for this problem or there is another module to be implemented ?

Thanks in advance

Posted 30-Apr-13 6:14am

AhmedYehiaK

Add a Solution

Comments

[no name] 30-Apr-13 12:43pm

So you have a common DB for all the clients ?

AhmedYehiaK 30-Apr-13 12:44pm

ahaaa i have a common DB for all clients

[no name] 30-Apr-13 12:49pm

So Data sync approaches that OP has suggested don't apply, first of all you need to identify the problem by doing some profiling. Try using fiddler for traffic information and use SQL profiler for SQL side of it.

AhmedYehiaK 30-Apr-13 12:51pm

there is no problem if there are another module to be implemented like Data sync approaches if this module will solve the problem

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pheonyx · Accepted Answer · 2013-04-30T06:24:00

There are various options to you, and this is a very broad approach to things.
It also depends how you want to operate.

If the sites do not need 100% up to date information then you could use Data Synchronisation approaches:
Choose a Data Synchronization Technology[^]

If they do need upto date information then you could work on a paging method when retrieving large amounts of data, or refine how your data is transmitted between them. When submitting information take advantage of threading and handling failures on a call back method. This means you can submit large amounts of data and keep using other aspects of the program while it submits if that suites your operation.

You could also look into compression which could be applied.

Without knowing much more about your system it is hard to advice but those are some approaches that could be considered.