Hello All,

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

Regards.

PocketSYNC Team

Hi bumerang

Examples? How can install SQLite in PPC? its special way?
How is ConnectionString, in PPC & Desktop?

Cheers,

RA

"bumerang" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello All,
>
> 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
>
> Regards.
>
> PocketSYNC Team
>
>
>

Hello,

We will publish demo version at next week, I will send web link to group.

Thanks.

"ralvaradot" <(E-Mail Removed)>, iletide þunu yazdý
news:uDft1$(E-Mail Removed)...
> Hi bumerang
>
> Examples? How can install SQLite in PPC? its special way?
> How is ConnectionString, in PPC & Desktop?
>
> Cheers,
>
> RA
>
> "bumerang" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hello All,
> >
> > 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
> >
> > Regards.
> >
> > PocketSYNC Team
> >
> >
> >
>
>

What kind of size are we talking about? What kind of space does it take on
the device?

"bumerang" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello All,
>
> 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
>
> Regards.
>
> PocketSYNC Team
>
>
>

Just 220 Kb !

"Jamie Macleod" <(E-Mail Removed)>, iletide þunu yazdý
news:(E-Mail Removed)...
> What kind of size are we talking about? What kind of space does it take
on
> the device?
>
> "bumerang" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hello All,
> >
> > 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
> >
> > Regards.
> >
> > PocketSYNC Team
> >
> >
> >
>
>

Nice!

"bumerang" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Just 220 Kb !
>
> "Jamie Macleod" <(E-Mail Removed)>, iletide þunu yazdý
> news:(E-Mail Removed)...
> > What kind of size are we talking about? What kind of space does it take
> on
> > the device?
> >
> > "bumerang" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Hello All,
> > >
> > > 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
> > >
> > > Regards.
> > >
> > > PocketSYNC Team
> > >
> > >
> > >
> >
> >
>
>

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

Hi Carl,

We are still faster than you. Searching single record in 10,000 record takes
<1 sec from none indexed table (I did not meausure yet but I know it just
takes several hundred milliseconds).

Regards.

"Carl Rosenberger" <(E-Mail Removed)>, iletide sunu yazdi
news:c2hs0u$tv9$03$(E-Mail Removed)...
> 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
>
>

bumerang wrote:
> We are still faster than you. Searching single record in 10,000 record takes
> <1 sec from none indexed table (I did not meausure yet but I know it just
> takes several hundred milliseconds).

Hi bumerang,

judging from your first posting, the query takes 8 seconds with
your engine.

Why don't you simply prove your statement by providing a simple
..NET App to support your claims?

Here is mine:
http://www.db4o.com/db4o/race10000.zip

The above Zip File (127 kB in size) contains the current development
build of our object database engine and a small Windows forms
application that tests and documents query execution speed.

The Zip is supplied as a VS.NET 2003 project along with the source
code of the application. You may need to reset the reference to
db4o.dll since VS.NET projects loose references if a project is
moved (I suppose this is a bug.).

(The db4o 3.0 build can not be used for productive use. It's our
current development build and it's not stable yet. The first 3.0
beta versions are scheduled for the end of this month. For
productive projects, please use db4o 2.8.)

I would appreciate if you could produce something similar, bumerang.
Feel free to use the sources of my small test application.

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

What is the size of your database engine on the PocketPC device?

"bumerang" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi Carl,
>
> We are still faster than you. Searching single record in 10,000 record
takes
> <1 sec from none indexed table (I did not meausure yet but I know it just
> takes several hundred milliseconds).
>
> Regards.
>
> "Carl Rosenberger" <(E-Mail Removed)>, iletide sunu yazdi
> news:c2hs0u$tv9$03$(E-Mail Removed)...
> > 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
> >
> >
>
>