VC++ Efficient Database with zero mentainence

Question

0.00/5 (No votes)

See more:

Hi All,
We are using sqlite3 as back-end database with vc++ code in our software.We are not using MySql or other DB, as it will have an maintenance overhead for client [e.g. install the My sql server then start the server etc.].But as sqlite3 is is made for embedded system they are little slow for out product [even though I have changed the sqlite3 PRAGMA to make it fast and it improved the speed also. still its slow for sorting,duplicate check etc. and as its a single flat file we have some limitation.].

C#

execDML("PRAGMA synchronous = OFF;");
           //execDML("PRAGMA journal_mode = OFF;");
           execDML("PRAGMA locking_mode = EXCLUSIVE;");
           //execDML("PRAGMA temp_store = MEMORY;");
           //execDML("PRAGMA count_changes = OFF;");
           execDML("PRAGMA PAGE_SIZE = 4096;");
           execDML("PRAGMA default_cache_size=700000;");
           execDML("PRAGMA cache_size=700000;");
           execDML("PRAGMA compile_options;");
           execDML("VACUUM;");

My question is there any better and faster DB than sqlite3 that can integrate with VC++ without installing or configuring it?

Posted 4-Jul-12 22:32pm

shankha2010

Add a Solution

Comments

ThatsAlok 9-Jul-12 7:38am

you are using one of the best embedded DB currently available.. it work every where from embedded devices to WEB.

2 solutions

Solution 2

There are really only 2 types of databases, embedded and server.

Embedded use a "driver" from your application to access the database. They don't need to be installed. Memory, etc is managed from the driver.

Server have a dedicated OS thread (or more) for the database in the PC. That thread can cache results, resolve conflicts (collisions between multiples writes and reads), delay writes, improve database files when idle.
That database dedicated thread can also handle memory better, security, etc. It can also handle network access.
But in order to use the database the "database process" must be installed and lanched.

For embedded, I think SQLite is one of the bests. But it won't allow multiple writes (multiuser), and performance will never match a dedicated thread server database.

Posted 7-Jul-12 8:19am

ErnestoNet

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)

**ThatsAlok** · Accepted Answer · 2012-07-09T01:38:00

Solution 3

try this link http://en.wikipedia.org/wiki/Embedded_database[^]

one of DB looks good there is http://en.wikipedia.org/wiki/EXtremeDB[^]

Posted 9-Jul-12 1:38am

ThatsAlok

Updated 9-Jul-12 1:44am

v2

Comments

ThatsAlok 10-Jul-12 2:48am

Just a small question for 3 voter? what the wrong with this answer.Wikipedia have given a large page on this topic and i giving link for same. doesn't 3 voter browse that link before voting!