Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What database to use for a Pocket PC application? 1
- Thread starter EwS
- Start date
- Thread starter
- #2
-
1
- #3
TonyScarpelli
Programmer
I think it depends on how many tables and records you are going to use.
If it's a short list, one of the third party database managers is probably fine, or even use the .Net SQL tables.
You can use XML, but only recommended for short tables.
I've found SQL tables for large tables too cumbersome and slow. It takes too long to download into the device. It might take 45 minutes for an initial download.
In my case where I have to download 7 meg of data I use text files, something like the old random access files in Basic, because they are so fast. Just a few seconds to about a minute or so for large files
You can use text files as lines of data and then pick out the fields from each line as long as they are of fixed lenght, or even delimited files. Or you can use one continuous file where each record is a single length, and each field is a fixed length, and then you can point anywhere into the file to get a row, then extract the data fields into an array.
Hope this helps.
Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102
If it's a short list, one of the third party database managers is probably fine, or even use the .Net SQL tables.
You can use XML, but only recommended for short tables.
I've found SQL tables for large tables too cumbersome and slow. It takes too long to download into the device. It might take 45 minutes for an initial download.
In my case where I have to download 7 meg of data I use text files, something like the old random access files in Basic, because they are so fast. Just a few seconds to about a minute or so for large files
You can use text files as lines of data and then pick out the fields from each line as long as they are of fixed lenght, or even delimited files. Or you can use one continuous file where each record is a single length, and each field is a fixed length, and then you can point anywhere into the file to get a row, then extract the data fields into an array.
Hope this helps.
Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102
- Thread starter
- #4
- Status
Similar threads