Re: [sqlite] Critical issue

> Alternatively, you could recompile SQLite.Interop.dll to use the > static CRT library (/MT). Could you please let me know how to proceed to do this? Thanks again, Regards, Cyrille Le 22/06/2011 21:48, Random Coder a écrit : > On Wed, Jun 22, 2011 at 10:57 AM, Cyrille

[sqlite] Sqlite3 WAL (file is encrypted or is not a database, database table is locked, database disk image is malformed') at high load

I am using sqlite3(sqlite-3.7.0.1) with WAL enabled as storage for a multiprocessing daemon(python). On doing a BULK insert of .5 million rows each of size 230 bytes in batches of 500 where each batch is a transaction, following errors happen in other processes which perform (<10) SELECTS and

Re: [sqlite] Query with UNION on large table

On 23 Jun 2011, at 1:00am, Rense Corten wrote: > @Simon: I don't have a problem per se with things running overnight, > as long as I can be sure that things will complete at some point...the > result of "PRAGMA integrity_check;", which by the way took less then > an hour, is "ok". Any

Re: [sqlite] Query with UNION on large table

Thanks Simon, Jim and Tom for your replies! @Simon: I don't have a problem per se with things running overnight, as long as I can be sure that things will complete at some point...the result of "PRAGMA integrity_check;", which by the way took less then an hour, is "ok". Any suggestions? @Jim:

Re: [sqlite] Query with UNION on large table

Thanks Simon, Jim and Tom for your replies! @Simon: I don't have a problem per se with things running overnight, as long as I can be sure that things will complete at some point...the result of "PRAGMA integrity_check;", which by the way took less then an hour, is "ok". Any suggestions? @Jim:

[sqlite] Bug with fts3 when using a restrictive authorizer.

If the authorizer prevents PRAGMA, then fts3 fails with an SQLITE_AUTH error from fts3DatabasePageSize(). http://crbug.com/85522 is the Chromium bug where this originated (I upgraded the Chromium SQLite version a few weeks back). http://codereview.chromium.org/7230021 is the short-term patch I'm

[sqlite] Query performance issue

Hi all. We're trying to get the following query working at a better speed and I'm wondering if anyone has any ideas on optimizations we might be able to do. The query groups e-mail addresses and gives us the total number of each address seen within a given time range of messages, ordering from

Re: [sqlite] Critical issue

On Wed, Jun 22, 2011 at 1:11 PM, Cyrille wrote: > I confirm also that my project was set to "anycpu". If I change the > setting to "x86", is the VS 2010 C++ Redistributable package still > necessary? Yes. ___ sqlite-users mailing

Re: [sqlite] Critical issue

Thank you so much to all of you for your feedback. One of my users just informed me that he solved the issue by installing indeed the VS 2010 C++ Redistributable package. I confirm also that my project was set to "anycpu". If I change the setting to "x86", is the VS 2010 C++ Redistributable

Re: [sqlite] Critical issue

And the ieshims or whatever that doesn't show up in dependancy walker is standard behavior for any C# application. On Wed, Jun 22, 2011 at 12:55 PM, J Decker wrote: > This is actually probably a very simple problem.  sqlite.net library > is built as x86.  Your project is

Re: [sqlite] Critical issue

This is actually probably a very simple problem. sqlite.net library is built as x86. Your project is probably built as 'anycpu' instead of 'x86' which allows it to try and run as x64 as appropriate, but it won't be able to use the x86 sqlite.net library. On Sat, Jun 18, 2011 at 5:47 AM, Cyrille

Re: [sqlite] Critical issue

On Wed, Jun 22, 2011 at 10:57 AM, Cyrille wrote: > As you said, I have been surprised by the result. One of my users copied > the missing DLL indicated by Depends (IEShims.dll) to the application > folder and Depends indicates now another missing DLL: ieframe.dll which > seems

Re: [sqlite] Query with UNION on large table

This is even faster, on a tiny table: SELECT n1, n2 FROM table1 INTERSECT SELECT n2, n1 FROM table1 WHERE n2

Re: [sqlite] Query with UNION on large table

Did you try to time a simpler select: SELECT min(n1, n2) as new1, max(n1,n2) as new2 FROM table1 group by new1, new2 having count(*)> 1 ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Critical issue

Hi Michael, As you said, I have been surprised by the result. One of my users copied the missing DLL indicated by Depends (IEShims.dll) to the application folder and Depends indicates now another missing DLL: ieframe.dll which seems to be again linked to IE. Well, I have the feeling that the

Re: [sqlite] Query with UNION on large table

On 22 Jun 2011, at 6:36pm, Simon Slavin wrote: > With a billion rows, I forgot to say that there shouldn't really be a problem with a database of this size. If you have a single-user single-process use for a database of this size there's no reason SQLite shouldn't be a good solution for you.

Re: [sqlite] Query with UNION on large table

On 22 Jun 2011, at 6:25pm, Rense Corten wrote: > This has the desired result on a small example, but when I try this on > my actual table which has about 800 million rows, the query never > seems to complete. It has been running for a couple of days now, and > it doesn't seem sqlite is still

[sqlite] Query with UNION on large table

Hi list, I am rather new to sqlite, and try to use it to manage a large database. The problem I have is the following: I Have a table "table1" that looks like this: n1,n2 1,3 3,1 2,3 3,2 2,4 thus there exists "reverse copies" of (1,3) and (2,3), while there is no such copy of (2,4) . I want to

Re: [sqlite] openmpi parallel problem

> there are no statements open, as far as i can see. Your eyes can miss something. Does sqlite3_close return SQLITE_OK or something else? Pavel On Wed, Jun 22, 2011 at 12:36 PM, Thorsten Kersting wrote: > there are no statements open, as far as i can

Re: [sqlite] openmpi parallel problem

there are no statements open, as far as i can see. On 06/22/2011 05:29 PM, Pavel Ivanov wrote: > Do you check result code of connection closing? Is it successful? > If it's not successful then some statements are still active and > reading transaction is still open. That could be the reason of

Re: [sqlite] openmpi parallel problem

Do you check result code of connection closing? Is it successful? If it's not successful then some statements are still active and reading transaction is still open. That could be the reason of error in write process. Pavel On Wed, Jun 22, 2011 at 10:58 AM, Thorsten Kersting

[sqlite] openmpi parallel problem

i use openmpi fo parallelization, an c++ as the interface to sqlite. in my program one process only writes into the database, and the other processes read at the beginning, and then never do anything with it. But even when i close the database-connection of the non-writing processes, my write

[sqlite] Spatialite RTree index

Hello, I have a spatial table with about 1 million rows (extracted from the italian ways shapefile). I create a spatial index on that table. Then, I tried to perform the same query; the first time I have not used the index, the second one I tried to take full advantage from it. But, the

Re: [sqlite] unexpected effect of view nesting on type conversion

> I've run into a phenomenon I don't understand where view nesting affects > types. > Seen in sqlite 3.7.6.3. > sqlite-3.6.23 does NOT show this behavior. I don't know though when the change happened. Mark ___ sqlite-users mailing list

Re: [sqlite] [PATCH] Won't compile on archaic OS

On Tue, Jun 21, 2011 at 7:29 AM, H.Merijn Brand wrote: > On Mon, 23 May 2011 18:45:14 +0200, "Bugs in DBD-SQLite via RT" > wrote: > > > See also > > https://rt.cpan.org/Ticket/Display.html?id=68396 > > This (rather clear) bug report neither

Re: [sqlite] [PATCH] Won't compile on archaic OS

On Mon, 23 May 2011 18:45:14 +0200, "Bugs in DBD-SQLite via RT" wrote: > See also > https://rt.cpan.org/Ticket/Display.html?id=68396 This (rather clear) bug report neither got any acknowledgement, not does it appear in the RT trackers. Meanwhile things got even

Re: [sqlite] unexpected effect of view nesting on type conversion

>I've run into a phenomenon I don't understand where view nesting affects >types. Give me a try: Form what I understand, views don't have their own types, so default affinity applies. 12.0 gets converted to 12 as an integer in v2 when the value gets picked from v1. Please someone correct me

[sqlite] unexpected effect of view nesting on type conversion

Hi, I've run into a phenomenon I don't understand where view nesting affects types. Seen in sqlite 3.7.6.3. The following is my attempt at a minimal case that produces this behavior. Here a real is unexpectedly converted to int. CREATE TABLE customer ( id INT, PRIMARY KEY (id) );