[dba-VB] C# Databases without borders

Three ways:

Binary array stored in the application as a resource and do that analysis yourself on the array 
elements.

SQLite - http://www.sqlite.org/

Access mdb

The  first  way is probably the optimum, but will require a bit more coding to do the analysus.

With only 40,000 rows stored as a collection or array, the in-memory scanning and 
summation should be near instant ( at least it would be if I did it in Powerbasic <g>)

-- 
Stuart 


On 11 Jan 2011 at 10:58, jwcolby wrote:

> I want to build a little application where I have a very simple zip
> code table of about 40 thousand zip codes, with things like household
> count, population count, lat and long.  My application would take
> lists of zip codes and sum the population and household counts, count
> the zips etc and put a count on the screen in a table format.
> 
> I already do this using SQL Server to hold the zip code table.  I get
> the zip lists into csv files, then create a table inside of SQL
> Server, join on the zip code and sum the population and household
> counts.
> 
> Now I want to build an application to do this but SQL Server is way
> overkill.
> 
> Can I use a csv or even xml to hold the zip table, create an xml table
> to hold the zip lists entered by the user and so forth.  IOW I need a
> low impact alternative to SQL Server.  Even express is just way
> overkill for this.
> 
> Somewhere in the back of my mind I am thinking that ADO.net knows how
> to load tables, create relationships between tables, enforce the join
> etc.  IOW do the store entirely in XML and just use ADO to do the
> rest.
> 
> Is this possible?  Would the speed be acceptable for a join between
> tblZipMaster and tblZipUserXyz on Zip count(zip) sum(household) etc.
> directly in memory. -- John W. Colby www.ColbyConsulting.com
> _______________________________________________ dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 
>