PPC development question

[Guest]

Hi All,

I am newbie to Pocket PC development; I have decent experience in .Net
Windows and Web. I am writing this not to ask any technical question but to
get an idea for developing an application. My employer asked me build a
Stocktaking application in PPC. The database has around 30,000 items and they
want the ability to do off-line and on-line stocktaking. The Item table has
around 25 columns, but for off-line basically I download 5 columns ( code
nvarchar(25), description nvarchar(30), quantity float , price money ,
location nvarchar(25) ). Now my question is when I download 30,000 items
into PPC; what sort of approach I should take into consideration because I
built small apps in PPC and that apps connected to SQL Server 2000 and
downloads the items into the local SQL Server CE 2.0 database. It takes hell
lot of time to download these items. What will I do in this scenario? What is
best way of building these sort of application. What is the best way to
approach this issue? Please guys help me in this issue and share your ideas.

give me some solution???????????

Thanks
Tom

 

[Norbert]

Hi

Why not sinc the DB via active sync (or over the Docking station)
You have your local DB and everytime when you put the PPC back in the
dockingstation
the Device is synchronised

How do you download the database to the PPC?
Probably you coud try to optimize your Select statement?
ore even create an export File on the server, and only transfer this
file to your PPC
(through your speecs I estimate it should have abou 3 MB, thats not
really big)

Also a good approach would be better hardware
We have here an Dell Axim x50v. It has an 600mhz CPU
Its really fun to work with it


Norbert