David McAfee
davidmcafee at gmail.com
Tue Jan 11 14:22:33 CST 2011
If the app is a single user app, you can also use C# and SQLCE. You can pass the datasets to and from the user via a web service. D On Tue, Jan 11, 2011 at 12:12 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote: > 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 > > > > > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >