-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/10/12 05:47, Chris Sonon wrote:
> I would like to house my database in a ZIP file and extract the
> database to a memory stream and then open it directly from the memory
> stream? Is this possible? If so, how?
You can get a zipvfs from the
Joe Mistachkin wrote:
>
> Good idea; however, I'm going to implement the column index caching using
a
> Dictionary, which will result in slightly more efficient operation.
>
The changes can be seen here:
http://system.data.sqlite.org/index.html/ci/bdd8e44fd0
I'm curious what
Matthew Dumbleton wrote:
>
> I'm afraid this doesn't seem to fix the issue.
>
Odd, it seemed like a disposal race condition. I thought the additional
locking
semantics would fix it. On the desktop versions of the .NET Framework,
there is
an actual CriticalHandle class and the necessary
Ashish Kulkarni wrote:
> Hello,
>
> I've attached a patch which caches the column names in SQLiteDataReader.
> During profiling a scenario where more than 100-200 records are read and
> columns are accessed by name and not by index -- well over 50% of the time
> was spent in
Hi,
I am looking for a diagramming tool for a sqlite
database. I want functionality similar to the diagrammer in sql server
management studio. Any suggestions?
Bill
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 10/05/2012 04:29 AM, Jonathan Engle wrote:
Ok, so here's a question (trying an experiment to see if this will
work, but throwing it out here as well).
What if the source db handle for the backup is opened to use private
cache? Will this have any effect at all or is it the cache mode of
db2
Michael,
Completely agree with your conclusion the GC.Collect is pretty much a plaster
over a severed limb, it's just hiding the problem rather than solving it. Just
mentioned it in case that gave Joe any ideas.
My code is all c# and the link privided I believe is a c++ only feature. I
It would seem to me that if GC.Collect fixes the problem than all you've done
is move the problem to someplace else that isn't fatal (at the moment) and
could rear its ugly head at most any time.
The reason your emulator doesn't throw the error would be for the same
reason...different memory
Don't know why the patch didn't get through, sending again...
===
diff -ur a\System.Data.SQLite\SQLiteDataReader.cs
b\System.Data.SQLite\SQLiteDataReader.cs
--- a\System.Data.SQLite\SQLiteDataReader.csSat Aug 11 16:40:46 2012
+++ b\System.Data.SQLite\SQLiteDataReader.csFri Oct 05
Hello,
I am currently developing a program that will use an sqlite database and I
would like to know if it is possible to load a database from a memory stream in
c#?
I would like to house my database in a ZIP file and extract the database to a
memory stream and then open it directly from the
Hello,
I've attached a patch which caches the column names in SQLiteDataReader.
During profiling a scenario where more than 100-200 records are read and
columns are accessed by name and not by index -- well over 50% of the time
was spent in System.Data.SQLite.SQLite3.ColumnIndex(). The attached
Thank you for your answer Mr.Simon Davies, but it seems that in a sqlite
format 3 file (that i have), the offset 28 value is not valid(not equal to
the file size) and surely not equal to offset 92 (00 00 00 00), what i am
trying to do, is extract an SQLite Format 3 file from the hex code of
To connect to SQLite I recommend the VB wrapper written by Olaf Schmidt:
http://www.thecommon.net/
There are plenty of examples to connect to SQL Server with VB, ADO and ODBC.
A simple Google search will find them.
RBS
On 10/5/12, Jorge wrote:
> Thanks
> I forgot to
Thanks
I forgot to include coding language (vb)
Do you know where can i find a sample code.
Thanks Again
Sent from my iPhone
On Oct 4, 2012, at 4:47 PM, Bart Smissaert wrote:
> What is your coding language?
> If VB then maybe via ODBC and ADO.
>
> RBS
>
>
> On Thu,
Joe,
I'm afraid this doesn't seem to fix the issue.
Just out of interest are you able to run the code I sent on a real device or in
an emulator? I'm testing on a Motorola ES400 and didn't initially think to try
switching to the emulator which doesn't seem to throw the error (still testing
15 matches
Mail list logo