Building a server-client application where client gets data from server, that stored on server locally C++.

Question

0.00/5 (No votes)

See more:

Building a Server-Client application where client gets data from server, that stored on server locally C++.

Server is fetching data from a database and storing it locally, and client is using that data by connecting to it.

Data is about various clients differentiated by various client id's.
There are lakhs of clients.

"Main aim is to search and fetch data very fast on basis of client id."

Need suggestions on which data structure we should use to store data locally, and this should be stored in sorted manner or unsorted and which searching technique we must use.

Many thanks for all your suggestions.

What I have tried:

Thinking to store data in BST for fast retrieval as fast searching and retreaving is main aim.

Posted 20-Mar-18 23:43pm

Vishal Bhatia0112

Updated 21-Mar-18 21:54pm

v2

Add a Solution

Comments

Richard Deeming 21-Mar-18 17:52pm

Caching: What could go wrong? – Buck Hodges[^]
Some people, when confronted with a performance problem, think "I know, I'll add a cache." Now they have two problems.

As Jochen said, putting a cache in front of a poorly-performing database is rarely the correct solution.

3 solutions

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)

Jochen Arndt · Answer 1 · 2018-03-20T23:53:00

If you have a database you already have a storage that supports various methods like fetching, filtering, and sorting.

So there should be no need to create another storage holding data stored also in the database. It might also lead to unwanted side effects when the storages are out of sync.

For performance optimisation used stored procedures to retrieve data from the database. The performance depends also on your database design. So using a proper design is essential.

Vishal Bhatia0112 · Answer 2 · 2018-03-21T18:28:00

Solution 2

Yes, we have database.
but there are millions of hits on database daily.

So,to make it more fast was thinking to store some data locally.

Posted 21-Mar-18 18:28pm

Vishal Bhatia0112

Shortground · Answer 3 · 2018-03-21T21:55:00

Solution 3

deploy a search engine maybe a better way, using information retrieval technology.
data can be compressed and store locally

Posted 21-Mar-18 21:55pm

Shortground