Re: SQL Server/Access alternative?
Date: Mon, 13 Dec 2004 18:24:23 -0500
On 13 Dec 2004 01:52:18 -0800, firstname.lastname@example.org wrote:
>I'd like to explore the possible database strategies for use in my PPC
>application. I'm developing in VB.NET 2003. My application stores
>potentially thousands of records, with lots of lookups. The tables
>themselves do not have a lot of columns, though. The main prerequisite
>for this database is speed, followed closely by memory footprint, then
I actually use comma-delimited text files. I can read and store 45,000
records in 30 seconds on a 200 MHz ARM. I do that infrequently, so
users don't mind the delay. When I parsed all those records as I read
them, I needed several minutes, and users did object (I sure don't
blame them). I don't know how much time I need to access and parse
individual records after that. I do know that I need about 1 second to
read and parse a bunch of records and rearrange my screen; this all
happens right after a user enters data, so users don't mind that delay
>I need something I can access programmatically, using SQL, preferably,
>so applications like XSDesigner/XSForms/EasyDB aren't what I'm looking
>I don't want to use SQL Server CE. When I bundle my app, having the
>SQL Server CE Query icon appearing in the Program folder somehow looks
>weird. :) I don't know of any way of suppressing this.
>I've looked at XML files to store the data, loading them into the
>device's memory via ADO.NET recordset, and manipulating them in memory,
>but I understand this takes up a lot of memory space. I've also
>looked at Pocket Access, but .NET does not have a native provider for
>Access. I know InTheHand provides this, but I have to pay for it, and
>it's something I try to avoid as my application will probably be
>released as freeware anyway, so I'd try not to incur additional costs.
>I've tried looking in both web and usenet, but I still can't find
>anything. :( Is there anything else I can try? Even if I have to pay?
>Thank you very much.
To reply to me, remove the underscores (_) from my email address (and please indicate which newsgroup and message).
Robert E. Zaret, eMVP
500 Harrison Ave., Suite 3R
Boston, MA 02118