Re: [nbos] Astro3 Experimental Build"Chris Tavares" Fri Nov 13th, 2009
SQLite isn't supported directly by the .NET framework, but you can get a
third-party provider here: http://sqlite.phxsoftware.com/
No idea if it works in 2010.
From: nbossoftware-bounces-at-nbos.com [mailto:nbossoftware-bounces-at-nbos.com]
On Behalf Of Carl Hess
Sent: Friday, November 13, 2009 8:26 AM
To: NBOS Software
Subject: Re: [nbos] Astro3 Experimental Build
I messed with it a bit last night. I noticed an increase in sector size
converting from 2 to 3 (13k to 15k) and it didn't take too long. It did
take a while to open the file after it was converted, and I noticed that the
conversion process didn't save the file as AstroDB, but rather, with a
.sector extension as under 2.0. This is probably by-design, forcing the
user to explicitly save their converted, opened file, but it was a little
SQLite is kind of a pain. The have a .dll that contains their functions,
and I tried to reference it using C# in Visual Studio 2010 (beta 2) but it
was not recognized as a valid library file. It's probably unmanaged C or
C++, or it could be that 2010 just doesn't support that kind of thing yet.
I half-expected a .NET library for SQL to be included, but it's not there.
I'll do some more research on the System.Data libraries and see if SQLite is
supported. I started to tinker with their command line utility but it got
late. I'm going to install SQL Server 2005 tonight and see if I can
convert the AstroDB file to .SQL and back. The documentation for SQLite
seems to indicate it's supported, but this may not be the best way to go for
manipulating the data in the sector and loading it back into the program.
Thanks again for the beta opportunity.
> Date: Fri, 13 Nov 2009 00:55:44 -0500
> To: nbossoftware-at-nbos.com
> From: support2-at-nbos.com
> Subject: Re: [nbos] Astro3 Experimental Build
> I'm going to make some tweaks to the converter to handle larger files
> better. The one main drawback of using a database is that it is slower
> writing to the database than it is writing to a standard file format. Of
> course, one of the reasons its slower because its more reliable. I
> anticipate in the actual v3 release, a lot of the saving will be done in
> the background. It also probably wouldnt hurt if there was some sort of
> progress status feedback on the conversion as well.
> The converter wasnt unloading bodies from memory after they were saved to
> the database, which is the normal procedure as a file gets saved, so thats
> whats behind the ram usage.
> At 04:24 PM 11/12/2009, you wrote:
> >I've noticed my sector file is double the size with the new file format,
> >my original sector was only 2,394kb the new one ends up being 5970kb,
> >Attempting to reconstruct a 81MB sector file, noticed that Astro3 is
> >chugging at it at 3-5% of my CPU (Dual Core 2.5ghz) during the
> >I'm waiting for the mem usage to reach around double the filesize before
> >shut it down. (this may take a but)
> Nbossoftware mailing list
Windows Live: Friends get your Flickr, Yelp, and Digg updates when they
Nbossoftware mailing list