From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1Nwd1S-0002cB-Te for garchives@archives.gentoo.org; Tue, 30 Mar 2010 15:06:31 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 7BCFFE0CE7 for ; Tue, 30 Mar 2010 15:06:30 +0000 (UTC) Received: from foo.birdnet.se (foo.birdnet.se [213.88.146.6]) by pigeon.gentoo.org (Postfix) with SMTP id 8D328E0D03 for ; Tue, 30 Mar 2010 14:18:00 +0000 (UTC) Received: (qmail 17004 invoked by uid 501); 30 Mar 2010 14:17:59 -0000 Message-ID: <20100330141759.17003.qmail@stuge.se> Date: Tue, 30 Mar 2010 16:17:59 +0200 From: Peter Stuge To: gentoo-embedded@lists.gentoo.org Subject: Re: [gentoo-embedded] help in choosing DB engine for embedded application Mail-Followup-To: gentoo-embedded@lists.gentoo.org References: Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-embedded@lists.gentoo.org Reply-to: gentoo-embedded@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Archives-Salt: 846ba33a-219f-494a-8687-51cd437c6f72 X-Archives-Hash: 1986daa532208c405ceb27c4228ab6ee Hi Mirage, Mirage ha wrote: > I do not know if this is the correct place to post this question or > not but as you have experience in embedded field i expected you > will help me. Although the question is not very specific to Gentoo I do agree with you that it can be relevant in this group. > I facing a problem in choosing database engine for my application > my manager suggested to use files (e.g. txt files ) , i suggested > to use berkeley db. > So could you tell me which is better and if there is better solution > (better db engine) please tell me. Unfortunately there is no simple answer to this question. The best solution depends on many things that probably only you or your department knows; data structure, data access patterns (reads/writes 1:1, 10:1, 100:1 ?), number of updates per time period, size of updates, and so on, and so on. Choosing the best database solution is always a difficult task. > also if there is link to good database benchmark comparison please > send it. For the reasons I mention above it is also very difficult to create good database benchmarks. Some databases already include a benchmarking suite, but that will be tuned to the particular workload that the particular database handles the very best. It's marketing basically. Besides performance there can also be factors such as time to market/previous developer experience to consider - if the system does not have a critical performance requirement then it may be better to choose a database which allows the most rapid delivery of the product. And there are even further dimensions to the database question - it is a very difficult one to answer. If you can describe some of the things I mentioned above, in particular the properties of your data, and the access patterns, then it may be possible for people to offer suggestions - but knowing more about the application may also only lead to more questions needed to find the best answer. //Peter