I NEED A TRICK TO A FAST ACCESS DATABASE IN THE POCKET PC

Hi!

I am doing an application for a warehouse. I have to scan products
in the warehouse with a Pocket PC and show the details of them.

My problem is that When I try to access to the database take me
around between 7-10 secons, That is a long time...because the people
from the warehouse need a fast access.

I am woeking with a Toshiba e740, with and access database inside,
1500 records and 6 indexes.

do you have any idea to improve the speed?

Thanks a lot in advance.

Gabi

ppcinfo
Wed Oct 15 11:21:59 CDT 2003

Where is your database file? Is it on an external storage card or in main
memory? I've found that having a database file (or volume) on a ext storage
card can be very slow because of the speed of the storage media.

Also, what part of accessing your database is slow? Is it when you scan for
a specific record, try to open the database, when you write to the database?

ppcinfo

"Gabi" <gabriel.renom@expansys.com> wrote in message
news:51ebf8c5.0310150703.27797e50@posting.google.com...
> Hi!
>
> I am doing an application for a warehouse. I have to scan products
> in the warehouse with a Pocket PC and show the details of them.
>
> My problem is that When I try to access to the database take me
> around between 7-10 secons, That is a long time...because the people
> from the warehouse need a fast access.
>
> I am woeking with a Toshiba e740, with and access database inside,
> 1500 records and 6 indexes.
>
> do you have any idea to improve the speed?
>
> Thanks a lot in advance.
>
> Gabi

Chris
Wed Oct 15 11:38:24 CDT 2003

There's something else wrong. 1500 records is not a lot, and you should be
getting data back very quick, even with eVB and ADOCE.

--
Chris Tacke, eMVP
Advisory Board Member
www.OpenNETCF.org
---
Windows CE Product Manager
Applied Data Systems
www.applieddata.net

"Gabi" <gabriel.renom@expansys.com> wrote in message
news:51ebf8c5.0310150703.27797e50@posting.google.com...
> Hi!
>
> I am doing an application for a warehouse. I have to scan products
> in the warehouse with a Pocket PC and show the details of them.
>
> My problem is that When I try to access to the database take me
> around between 7-10 secons, That is a long time...because the people
> from the warehouse need a fast access.
>
> I am woeking with a Toshiba e740, with and access database inside,
> 1500 records and 6 indexes.
>
> do you have any idea to improve the speed?
>
> Thanks a lot in advance.
>
> Gabi

hel
Wed Oct 15 11:50:44 CDT 2003

http://40th.com/gt40/bench_gt40_arm.html

G [15 Oct 2003 08:03:08 -0700]:
>do you have any idea to improve the speed?

Don't use bad software. Bad software is always wrong, slow,
and seriously bloated. Use good software, which is always
right, and seriously fast. The good software here is about
700x faster than the bad sofware you are using.

--
40th Floor - Software @ http://40th.com/
GT40 encryption-database toolkit

Mike
Wed Oct 15 16:31:39 CDT 2003

Gabi wrote:

> Hi!
>
> I am doing an application for a warehouse. I have to scan products
> in the warehouse with a Pocket PC and show the details of them.
>
> My problem is that When I try to access to the database take me
> around between 7-10 secons, That is a long time...because the people
> from the warehouse need a fast access.
>
> I am woeking with a Toshiba e740, with and access database inside,
> 1500 records and 6 indexes.
>
> do you have any idea to improve the speed?
>
> Thanks a lot in advance.
>
> Gabi

I had trouble with speed too so I switched to SQLCE. It didn't require
major code changes (even in my C++ app). I found it was a significant
performance inhancement.