Re: Database Alternative

From: Carl Rosenberger (carl_at_db4o.com)
Date: 03/08/04 

Date: Mon, 8 Mar 2004 14:27:55 +0100

bumerang wrote:
> We are developing .NET CF & DESKTOP interface for SQLITE database
> (www.sqlite.org) Its in a beta state and I want to inform you some test
> results about it. You can use it with VB. NET or C# for CF or DESKTOP. You
> can easily transfer SQLITE database device to desktop or else, and you can
> create/fill/use your db on desktop and then just copy to device for use.
>
> Test Device : IPAQ 2210,
>
> Library returns query results as DataTable objects so, you can use it
> directly with databound objects likes dbgrid etc.
>
> Record Length (100 byte, 1 integer primary key)
>
> Insert 10,000 record takes 17 second
> Select Query for 10,000 record takes 8 second
>
> Insert 10,000 record to MMC card takes 24 second
> Select Query for 10,000 record from MMC card takes 10 second

Hi bumerang,

I take your postings as a challenge to post the results of our object
database engine for a similar task.

We store objects, so I can't provide a result for an integer on it's
own. We should run another benchmark with something more complex with
some inheritance hierarchies.

However our figures for the simplest equivalent possible...

    public class SimpleInt
    {
        public int myInt;
    }

...look pretty good to me. Our indexing system clearly beats yours:

db4o version: db4o 3.0 B71 (alpha version)
Test Device: iPAQ 5450

(1) Indexed
------------
Inserting 10,000 objects takes 171 seconds.
A query for one indexed object in 10,000 objects takes 1.1 seconds.
The indexed database file has a size of 470kB.

(2) No Index
------------
Inserting 10,000 objects takes 128 seconds.
A query (scan) for one object in 10,000 objects takes 37 seconds.
The database file has a size of 390kB.

db4o 3.0 with indexed fields will be available for public BETA testing
by the end of this month. The release is planned for the end of May.

Of course I can provide test case and engine for the above results today,
if anyone would like to check my results.

I am positive that we will provide the fastest query processor available
for the CompactFramework and I am looking forward to further races with you.

Kind regards,
Carl 

-- 
Carl Rosenberger
db4o - database for objects - http://www.db4o.com

Relevant Pages

  • Re: Sessions count?
    ... Job notification exit points [as I infer] can be used to log start and stop timestamps. ... Logged to a database file, a query of the output could count the jobs that spanned a specific time. ...
    (comp.sys.ibm.as400.misc)
  • Re: Mail Merge query results with Office 2002
    ... I changed the select queries to a make table queries (user input ... Jerry M. Gartner ... I may end up doing a make table query - since only tables are there. ... Then choose your database file. ...
    (microsoft.public.access.queries)
  • Re: Make a report show content from an external Database
    ... You can create a query or modify the sql of a query to something like: ... This would allow you to create a record source for your report. ... So i have a database file with forms ... Dim qdf As QueryDef ...
    (microsoft.public.access.reports)
  • Re: Mail Merge query results with Office 2002
    ... sure why the queries aren't available but they aren't. ... database file, but the default file type is a Word document. ... Your next choice is to select the Table or Query containing the ...
    (microsoft.public.access.queries)