Re: Binary of flat File VS CE Database ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ginny Caughey [MVP] (ginny.caughey.online_at_wasteworks.com)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 17:59:53 -0500

Using your own file format can certainly work, and it might indeed be
fastest depending on how you write it. Other options include SqlCE, and if
the amount of data isn't large you could consider XML and CSV. There are
also commerical database products available for CE, and some of them have
great performance. 

-- 
Ginny Caughey
.Net Compact Framework MVP
"Jean Nicolas Turcotte" <jn_turcotte_microstep@yahoo.ca> wrote in message 
news:ufF5CzSGFHA.2032@tk2msftngp13.phx.gbl...
> Hi everyone,
>
> I have two sections here. First a questions, and I would like to know if I 
> am going the right way for my program cause I am a newbie in handheld 
> application.
>
> --------------------------
> First :
> I have read about the CE database properties and functions in Windows Ce. 
> But I still haven't use it.
>
> I was wondering the pros of using a CE Database file instead of a Binary 
> file ?
>
> The CE Database file isn't relational, the structure doesn't let you have 
> any specific sort order or any query, you need to use a seek to move your 
> cursor.
>
> It's look like it's have the same properties and functionalities as a 
> binary file ?
>
> --------------------------
> Secondo :
> I am trying to decide witch way to go for my program. I am thinking more 
> and more that I should go with a binary file. That way I could store 
> special information related to the table structure and how many records I 
> have etc... and in the same file have all my data related to this file.
>
> [header][nbr_records][nbr of params][size of 
> param1][sizeofparam2][sizeofparam 
> N][...][Address][Location][phone][buyer][...][/header]
> [data1_param1][data1_param2]
> [data2_param1][data2_param2]
> [data3_param1][data3_param2]
> [data4_param1][data4_param2]
> [...]
> [footer][information][/footer]
>
> Isn't it easier to use it that way, instead of having multiple table 
> containing a lot of information in it and manipulating all of this ? And 
> may be faster ?
>
> If I was on a desktop, I would use a SQL or Access Database to store all 
> this information. One table that contains all my data, one parameter 
> that's reference to an other table that contains the information stored in 
> the header.
> But on a handheld pc, I think it would slow it down and complicate 
> everything when you have many different forms, and each weeks you add new 
> forms. With binary file, I only have to create a new file each time the 
> user create a form, and delete it when it's have been transmitted to a 
> computer. (Just like what I was doing when working on old dos platform 
> :) )
>
> Am I wrong or I am doing the right thing ?
> Is there a better way to do this in WindowsCE 3.0 ?
>
> Thank you for your help ! It's appreciate.

Relevant Pages

  • Re: Best way to provide security when need a WindowsIdentity
    ... if you have to store the credentials - i would not recommend storing them in a db - use caching in the web server to cache them for a short period of time - don't cache the credentials in clear text. ... then use windows authentication and all access of files and SSPI ... database queries is done under the WindowsIdentity of the user. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: XP & Vista & Win 7 My Doc Directory Structure.
    ... Access XP and Access 2007 on Widows XP, Vista, and Windows 7. ... Rather than store the file in the database, ...
    (microsoft.public.access.formscoding)
  • Re: Data Files
    ... snip ... ... > In my file I need to store the following (mainly for a small ... > database): ... fixes many of the shortcomings of Windows 98 SE". ...
    (comp.lang.c)
  • Re: Windows mail can compact the message store.
    ... When Windows compacts the message store(or index) it is actually only doing ... Let it do the compaction to free up space. ... store (database) compaction. ...
    (microsoft.public.windows.vista.mail)
  • XP & Vista & Win 7 My Doc Directory Structure.
    ... Access XP and Access 2007 on Widows XP, Vista, and Windows 7. ... Rather than store the file in the database, ...
    (microsoft.public.access.formscoding)