Hi list:
I've an application who from a long time, worked in Windows 98; XP; Vista; W7,
and now in W8.
The things go fine until now, but with SQLite versions 3.7.15 and 3.7.15.1,
sqlite3_prepare_v2() fails and return 1.
Here is a brief of the situation:
1.- The application is running in a
Hello,
I have recently taken over a position that uses a SQLite
database. The database is currently 24GB and running extremely slow.
Is there a quick way to archive data and free-up some space? Also, are
there any risks to running the "vacuum" command...such as losing data?
I
Thanks Simon/devienne
Donald,
I just want my app to use the database. But as the database resides in a
common easy accessible location I want to lock the database or prevent any
access to it.
I don't want other apps or even user using that database. I just want to
block the writes. I am fine
Simon,
To answer your question, I want to stop modification when my app is not
running/alive.
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/Lock-Database-temporarily-tp66434p66454.html
Sent from the SQLite mailing list archive at Nabble.com.
Tou haven't said what "really slow" means.
Could be multiple solutions to that problem.
30min for 3-5MB sounds a bit ridiculous.
What kind of select are you doing to archive and what indexes are on the
tables?
-Original Message-
From: sqlite-users-boun...@sqlite.org
On 8 Jan 2013, at 2:05pm, "Jimmy Martin" wrote:
>I have recently taken over a position that uses a SQLite
> database. The database is currently 24GB and running extremely slow.
Your best friend here might be the SQLite shell tool:
a...@zator.com wrote:
>int resp = sqlite3_prepare_v2 (dbPtr, "SELECT ky,id,lev,pwd FROM
> dbOrig.usr", -1, , 0);
if (resp != SQLITE_OK)
printf("error message: %s\n", sqlite3_errmsg(dbPtr));
Regards,
Clemens
___
sqlite-users
You can also just copy the entire file (best to do when app is not running).
So you'd only be down for as long as it takes to copy it.
If your database is updated frequently .backup may never finish.
Then you can archive from the copy and delete the archived rows from the
active DB in a
>
> Mensaje original
> De: Clemens Ladisch
> Para: sqlite-users@sqlite.org
> Fecha: Wed, 09 Jan 2013 14:25:31 +0100
> Asunto: Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version
> andlater
>
>
>
>a...@zator.com wrote:
>>int resp =
On Wed, Jan 9, 2013 at 6:06 AM, wrote:
>
> >
> > Mensaje original
> > De: Clemens Ladisch
> > Para: sqlite-users@sqlite.org
> > Fecha: Wed, 09 Jan 2013 14:25:31 +0100
> > Asunto: Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version
>
I have narrowed this down and to just the System.Data.SQLite.DLL. I have a
test project in VS2010 with .NET 4.0. If I only change the
System.Data.SQLite.DLL from 1.0.79.0 to 1.0.83.0 I get the failure that the
file is open. I am not changing any other components or DLL's.
--
Michael Russell
One further follow-up. I tested all the other versions in between. The
break happened between 1.0.81.0 and 1.0.82.0
--
Michael Russell
MTI Film, LLC
michael.russ...@mtifilm.com
http://www.mtifilm.com/
Providence, RI 02906 USA
+1 (401) 831-1315
On Wed, Jan 9, 2013 at 10:47 AM, Michael Russell
Michael Russell wrote:
>
> One further follow-up. I tested all the other versions in between. The
> break happened between 1.0.81.0 and 1.0.82.0
>
The switch to using sqlite3_close_v2 happened in that time frame; however,
the root cause of the issue you are seeing is that one or more
>
> Mensaje original
> De: Pavel Ivanov
> Para: a...@zator.com, General Discussion of SQLite Database
>
> Fecha: Wed, 09 Jan 2013 16:08:51 +0100
> Asunto: Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.75 version and
> later
>
>
Everything that can be disposed of should be getting done automatically by
the using:
using (var testEntities = new TestEntities(connectionString))
{
Assert.AreEqual(1, testEntities.Users.Count(), "Must
be one user");
var firstOrDefault =
Does the Entity Framework make use of data adapters? If so, I just checked
in a fix to dispose the internal commands managed by the SQLiteDataAdapter
class (i.e. because the base class DbDataAdapter apparently does not
explicitly
dispose them).
Could you please try the latest trunk code and let
Joe Mistachkin wrote:
Does the Entity Framework make use of data adapters? If so, I just checked
in a fix to dispose the internal commands managed by the SQLiteDataAdapter
class (i.e. because the base class DbDataAdapter apparently does not
explicitly dispose them).
I don't know about data
Larry Brasfield wrote:
>
> I don't know about data adapter usage, but I am seeing the same behavior
> with Entity Framework version 5. I have scrupulously disposed of
> everything my code has gotten. I have also overridden the
> DbContext.Dispose(bool disposing) method and can see that the
I did do a check-out after you made the above suggestion to me. I did the
fossil checkout / build, but I still have the same problem.
--
Michael Russell
MTI Film, LLC
michael.russ...@mtifilm.com
http://www.mtifilm.com/
Providence, RI 02906 USA
+1 (401) 831-1315
On Wed, Jan 9, 2013 at 2:54 PM,
Hi, in xcompiling tools for winrt I get the errors below. I suspect this
because I am using the vcvars for cross compiling winrt. Is there a way to
make this work?
MSVCRT.lib(gs_report.obj) : error LNK2019: unresolved external symbol
__imp__IsDebuggerPresent@0 referenced in function
It sounds to me like your question has nothing to do with SQLite and
everything to do with the operating system your app is (not) running
on.
What facilities does your OS have to stop anything or anybody writing
a file? How do you propose to relax these facilities to enable your
app to write the
I see; well, that's unfortunate. At any rate, parsing lempar.c will
probably be much more complex than the code I have now, which solves a
simple (but common) case. Maybe I'll look into parsing lempar.c, but since
this solves my use case, I probably won't be in a hurry to do it. I
apologise to
This looks like general compile problem.
The imported functions below are found in kernel32.dll (kernel32.lib
import library). But I'm not sure whether under WinRT kernel32.dll is
still used (it might be).
If you can either add kernel32.lib to your link flags, or with pragma
#ifdef _MSC_VER
Thanks Dimiter. I ended up making this change in Makefile.msc
165 165 !IFNDEF NSDKLIBPATH
166 -NSDKLIBPATH = $(WINDOWSSDKDIR)\lib
166 +NSDKLIBPATH = $(WINDOWSSDKDIR)\Lib\win8\um\x86
167 167 !ENDIF
On Wed, Jan 9, 2013 at 4:07 PM, Dimiter 'malkia' Stanev wrote:
> This looks
I want to know sqlite version of android 4.0.3
It's bundle, so version is not know.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 10 Jan 2013, at 12:23am, sqlitekyounoii wrote:
> I want to know sqlite version of android 4.0.3
>
> It's bundle, so version is not know.
On whatever platform you're interested in, execute the SQL command
SELECT sqlite_version()
See this page for details:
Michael Russell wrote:
>
> I did do a check-out after you made the above suggestion to me. I did the
> fossil checkout / build, but I still have the same problem.
>
Is there any way you can determine which System.Data.SQLite objects are
being
held open by the Entity Framework?
--
Joe
Hi,
I don't know if it's the right mailing list to talk about
System.Data.SQLite.dll.
DbTransaction has a property Connection that corresponds to the connection
used by the transaction. I don't understand why calling Commit or Rollback
on the transaction automatically sets that property to null.
E. Timothy Uy wrote:
>
> Hi, in xcompiling tools for winrt I get the errors below. I suspect this
> because I am using the vcvars for cross compiling winrt. Is there a way to
> make this work?
>
In order to build for WinRT, extra options are required on the NMAKE command
line. Here is an
RizThon wrote:
>
> I don't know if it's the right mailing list to talk about
> System.Data.SQLite.dll.
>
Yes, this is the right place.
>
> DbTransaction has a property Connection that corresponds to the connection
> used by the transaction. I don't understand why calling Commit or Rollback
>
~Android gingerbread: 3.6.22
Honeycomb~ICS: 3.7.4
Jellybean~:3.7.11
On Jan 10, 2013 9:23 AM, "sqlitekyounoii"
wrote:
> I want to know sqlite version of android 4.0.3
>
> It's bundle, so version is not know.
> ___
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/13 16:23, sqlitekyounoii wrote:
> I want to know sqlite version of android 4.0.3
My 4.0 device is 4.0.4 but I doubt they changed it. The version number is
3.7.4 and the source id is 2011-02-23 14:33:31
> The Connection property is not guaranteed by the MSDN documentation to
> remain valid after a call to Commit or Rollback. It's really an internal
> implementation detail.
>
>
> http://msdn.microsoft.com/en-us/library/system.data.idbtransaction.connection.aspx
>
Indeed, I already checked MSDN
33 matches
Mail list logo