Re: SQL Server/Access alternative?

r_z_aret_at_pen_fact.com
Date: 12/13/04 

Date: Mon, 13 Dec 2004 18:24:23 -0500

On 13 Dec 2004 01:52:18 -0800, donyc@yahoo.com wrote:

>Hi...
>
>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
>storage requirements.

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
either.

>
>I need something I can access programmatically, using SQL, preferably,
>so applications like XSDesigner/XSForms/EasyDB aren't what I'm looking
>for.
>
>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.
>
>d.

-----------------------------------------
To reply to me, remove the underscores (_) from my email address (and please indicate which newsgroup and message).

Robert E. Zaret, eMVP
PenFact, Inc.
500 Harrison Ave., Suite 3R
Boston, MA 02118
www.penfact.com

Relevant Pages

  • SQL Server/Access alternative?
    ... I'd like to explore the possible database strategies for use in my PPC ... My application stores ... I don't want to use SQL Server CE. ... device's memory via ADO.NET recordset, and manipulating them in memory, ...
    (microsoft.public.pocketpc.developer)
  • Re: persistent cache in SQL Server
    ... If so, as Gregory said, it's not a cache. ... You can call WCF method and store the retrieved data into Session. ... Then store the retrieved data into database and use Sql Server Agent ... In fact, however, it can be good to have a copy either in memory and sql server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Does a text field takes more memory than varchar, even if the data is the same?
    ... Does a text field takes more memory than varchar, ... If you are using sql server 2005 or 2008 there are no difference ... but if you are using sql server 2000 and want to store a large string ...
    (microsoft.public.sqlserver.programming)
  • Re: Error saving resized bitmap
    ... a mapped server path, store it in your SQL server and then delete the ... read from the memory stream into a byte-array and store that data in the "image" field in SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Exchange 2003 Private Store Corruption
    ... Once you've pulled the faulty RAM, create the new mailbox store and move ... then you can start working on the problem mailboxes. ... have DIMM's installed in pairs in this server? ... Online Diagnostic Utility says "Correctable Memory Threshold Exceeded" ...
    (microsoft.public.exchange.admin)